Afternoon all,
I have a macro that compares dates but no matter what i try it doesn't seem to work.
Simply it goes a little like:
Dim cellDate 'Date that is in a certain cell
'format DD/MM/YYYY HH:MM.
cellDate = Cells(row, col) 'Varies depending on previous actions.
Dim formatDate 'cellDate formatted
'into same as i want to compare it to.
formatDate = Format(cellDate, "dd/mm/yyyy")
If formatDate >= "01/10/2005" Then
If formatDate <= "31/10/2005" Then
End If
End If
I have tried initialising the variable as dates, strings, variants, but none of the comparing IF statements work???
Any Help?
Thanks in advance!
Bookmarks