Thread: Macro to take user to a specific date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Macro to take user to a specific date
MsgBox Rows(1).Find(What:=Date).Address
OR
MsgBox Rows(1).Find(What:=Date).Column


If this post helps click Yes
---------------
Jacob Skaria


"Raggy" wrote:

I have a spreadsheet with dates running along the top row. I want to write a
macro to take me to todays date. Can this be done?
Reply With QuoteReply With Quote