Finding a Date
Hi,
Am trying to find a date on an Excel spreadsheet - tried the Find function
as below:
Cells.Find(What:="01/08/06", After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False).Activate
Problem is the date varies - hence the date needs to be in a variable.
Can't seem to get that part of it working - unsure of the syntax.
Anyone any ideas??
--
Many thanks in advance for any assistance
|