You have declared toDate as variant, fromDate as string.
You tried everything, so it may be silly to suggest

Dim toDate as Date, fromDate as Date

but that's what I'd use.

Best wishes Harald

"Ashman" skrev i melding
...
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?