View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gav Gav is offline
external usenet poster
 
Posts: 5
Default Avoid re-entering 'Find what:'

Col A contains a list of dates. In Cell B1 I enter a single date. How do I
write a macro to find the cell in Col A with the date which matches B1 and
make it the Active Cell. I could use Edit/Find but do not want to re-enter
the B1 date in 'Find what:'. I want the macro to use the B1 date
automatically.