Strange Values
Mate, many thanks, works perfectly. You are a life saver.
Jas
"Duke Carey" wrote:
don't DIM fromDate as a String. The way your DIM statement reads, toDate is
a variant. Cast them both as Date
"Ashman" wrote:
Hi all,
I am wanting someone to help me with my problem. I have a problem with dates.
Dim toDate, fromDate as string
toDate = sheets("data").cells(2,5).value
fromDate = Sheets("data").cells(2,27).value
The problem is that the value for toDate = 1/7/2001 and the value for
fromDate = "1/7/2002".
How do I take the "" out, I have tried everything? The only difference in
the above is the cell reference.
Can anyone help or suggestions would be great?
|