Use hot keys when recording your macro. For example Ctrl+Shift+Down
then Ctrl+Shift+Right. The hot keys will go as far as there is data.
On Jul 13, 10:18 am, amy wrote:
> Hello -
>
> My first ever attempt at posting - anywhere. I hope I'm doing this
> correctly.
>
> How do I set the range (So
/Average Solver.xls
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Ex
One more thing:
If you use variables and OnTime then never ever use the "End" command.
Rather make a goto to the end of the sub. If you end the macro with
"end" instead of "end sub" all variables will be deleted.
--~--~-~--~~~---~--~~
--
some cells aren´t entered as date. Their values are text with the format
xx-xx-xx
You´ve to enter every cell and change it to date, and then format the number
as you wish...
2009/7/13 sachin patil
> Hi,
>
> I'm Very new for this group.I'm facing problem in Excel in Date Formatting.
> When I'
Hello.
If Sheet1!R1C1:R403C71 is the only range of data on the sheet, then you can
use :
SourceData:="Sheet1!" & sheets("Sheet1").UsedRange.Address
If you have other data on the sheet, but R1C1:R403C71 is isolated by a blank
row and a blank column, then use :
SourceData:="Sheet1!" & sheets("Sheet1
Actually you are right vivek I went ahead i made a public declaration
instead.
Thanks,
Mog
On Mon, Jul 13, 2009 at 8:18 AM, vivek agrawal wrote:
> hi mog
> why do you want to define it inside the sub... isnt it fine outside it as
> it is already public
>
> Regards,
> Vivek Agrawal
> Skype ID - v
Hello -
My first ever attempt at posting - anywhere. I hope I'm doing this
correctly.
How do I set the range (SourceData) when I run pivot table code so
that the command will dynamically define the range. I need to run this
macro on files with different number of rows (always the same number
of
As stated before sleep is not a good option as the user is not able to
do anything in the meantime.
application.ontime is a much better alternative. here an example: (m2
being the name of the macro that will be executed)
time = Now + TimeValue("00:00:01")
Application.OnTime time, "ThisWorkbook.m2"
Hi,
I'm using RS232 ports a lot and so far have been using mscomm32 as
communication protocol. Since the last windows update (#...@?!$$
Microsoft) the old version of mscomm32 has been disabled (kill digit
set or something) to close a hole the IE had with executing some
functions (I don't know exac
Give a try at the following macro. However, check the columns from :
Cells(WhereToCopy, 9).FormulaR1C1 = "7/1/2009"
I am not sure it should be column 9.
Sub Macro2()
'
' Macro1 Macro
' ENTRY OF RENWAL DONE
'
' Keyboard Shortcut: Ctrl+Shift+A
'
Dim WhereToCopy As Long, myRange A
hi mog
why do you want to define it inside the sub... isnt it fine outside it as it
is already public
Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Mon, Jul 13, 2009 at 9:07 AM, obahor o wrote:
> For instance
>
> Dim Count As Integer
> S
Hi Jack
Please reply with an excel sheet attached containing your data and the
requirements... this would make understanding the problem easy
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Sun, Jul 12, 2009 at 8:18 PM, Jack wrot
Hello,
I need some help in creating an user form or input screen in excel so
I can input two number manually...my code is as follows:
I need to create some type of input box for specifying range numbers
1) f Range(WS_RANGE).Value > 6465 And Range(WS_RANGE).Value < 6469
Then and
2) If Range(WS_RA
Thank you for the quick reply. There were several responses saying the
same thing- delete (x,t) in the function equation and explaining it is
not necessary and obviously confuses the program. I look forward to
running the program with the corrected code.
On Jul 11, 5:00 am, "Daniel" wrote:
> Not
*This is the query by Chandresh Salva*
Enclosed please find the excel 2007 macro enabled – worksheet of macro.
This is the data entry of worksheet – where I am making data entry
I want to make the entry of whose renewal is submitted in the company.
I am marking Renewal – Pending – as to take
Hi,
What result do you need, it’s not quite clear to me ?
Best regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Nagendra Modupalli
Envoyé : lundi 13 juillet 2009 08:44
À : excel-macros@googlegroups.com
Cc : 26may.1...@gmail.com
Hi Sachin,
You have entered date which seems as date but actually are strings. You have
to write dated in the format mm/dd/yy. So your date should be 03/31/09, not
31-03-09.
This will solve your problem
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hi,
Use text to column wizard in 3rd step select date and "DMY" format all your
dates will be converted to data format
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of sachin patil
Sent: 13 July 2009 PM 03:00
To: Excel
S
Hi,
I'm Very new for this group.I'm facing problem in Excel in Date Formatting.
When I'm Selecting to Column & go to Option of Date in Format, Whole column
is not coming accoroding to that selected Date Format.
Can anybody help me out in this ?
Thanks in Advance
Sachin Patil
Dreams are today's
Thanks a lot.
On Mon, Jul 13, 2009 at 12:13 AM, Akhilesh Karna wrote:
> If you call Addval from your CntCell subroutine, the value of Count will be
> available in CntCell. That is, value of Count will be passed to Addval from
> the original subroutine.
>
>
> Akhilesh Kumar Karna
>
>
> On Mon, Jul
Hello.
It depends what you need to refresh :
Formulae, pivot tables, external data ?
Can you please precise ?
Regards.
Daniel
> -Message d'origine-
> De : excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] De la part de DARRELL GIBSON
> Envoyé : lundi 13 juillet 2009
Define it as “public” at the top of a standard module :
Public Count as Long
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de obahor o
Envoyé : lundi 13 juillet 2009 05:38
À : excel-macros@googlegroups.com
Objet : [Norton AntiSp
Dear Hemant,
You can protect your VB project with a good password and that would be the best
solution to your predicament! No one can then view your code, leave alone
modify them.
Sorry that I am unable to comment on the registry thing.
Anil Kumar Agarwala
Anil Agarwala & Co.
Chartered Acc
Hi Team,
Can you please help below template for Combo box.Thanks in advance.
I need month wise first and Location wise
--
Thanks&Regards
Nagendra.M
"LIFE IS TO LIVEE"...
--
Thanks&Regards
Nagendra.M
"LIFE IS TO LIVEE"...
--~--~-~--~~~---~--~--
If you call Addval from your CntCell subroutine, the value of Count will be
available in CntCell. That is, value of Count will be passed to Addval from
the original subroutine.
Akhilesh Kumar Karna
On Mon, Jul 13, 2009 at 12:37 PM, obahor o wrote:
> For instance
>
> Dim Count As Integer
> Sub
Hi Kunal,
I would suggest you use a batch command to populate this data.
Go to the folder in which you have the files and subfolders.
Create a .txt file. Open it and write this command - DIR /s /t > list.xls
Now change the name of the file by clicking on Save As and replacing the
extension of t
26 matches
Mail list logo
