Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to a particular Cell -Date
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to a particular Cell -Date
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). -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Shawn" wrote: 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 make 1 date cell automatically change another date cell | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
comparing abr. Date Text cell to a date formatted cell | Excel Programming | |||
Cell Blink or message if cells date = today date | Excel Programming |