date range vba code
One of those others is Microsoft.
--
Regards,
Tom Ogilvy
"Myrna Larson" wrote in message
...
I've heard others say that the bracket notation is very slow. I never use
it.
On Tue, 28 Sep 2004 06:52:20 GMT, Michael Bednarek )
wrote:
On Tue, 28 Sep 2004 00:10:59 -0500, Myrna Larson
wrote in
microsoft.public.excel.programming:
[snip]
But that isn't what you want in any case. You want to transfer the value
from
a cell into a variable, not select the cell. You do that by setting the
variable equal to the .Value property of the cell, like this:
[snip]
Cal_Date = Range("E1").Value
Start_Date = Range("D1").Value
End_Date = Range("D2").Value
... or simply:
Cal_Date = [E1]
Start_Date = [D1]
End_date = [D2]
[snip]
|