Thread: Finding a Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marek Marek is offline
external usenet poster
 
Posts: 7
Default 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