Go to a particular Cell -Date

[Shawn]

HI , I have a sheet which has a range of dates viz from the 1st of July 08
till 28th Feb 09. How do I create a macro or what formula do I use to be able
to go to the cell which has todays/ the current date on the sheet? ie if
today is the 30th of July 08 , How do I create a formula which will allow me
to go to todays date ?

 

[Wigi]

Hi

Normally, for purposes of finding something in a sheet, one would program
the Find method. Yet, to find dates, this is not very easy since the
formatting seems to play a role.

Hence, the easiest solution is to write a very small loop through the dates
and see whether it's today or not.

To prevent using a loop (which is a good thing), put a MATCH function in a
cell (aside). Then either use the HYPERLINK function, or write a very small
macro (a onelner will suffice, simply use Application.GoTo).