Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create macro to go to certain date within excel sheet?
How to create macro to go to certain date within excel sheet?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create macro to go to certain date within excel sheet?
For example,
Range("B:B").Find(Format(InputBox("What date?"), "mm/dd/yy"), , xlValues).Select Just make sure that your format string agrees with your sheet date formatting... HTH, Bernie MS Excel MVP "Mohamed" wrote in message ... How to create macro to go to certain date within excel sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a reference to a sheet that changes to todays date | Excel Worksheet Functions | |||
how to create a new sheet with today's date | Excel Discussion (Misc queries) | |||
How can you create a macro on a protected sheet? | Excel Discussion (Misc queries) | |||
create a macro to save excel sheet | Excel Worksheet Functions | |||
How do I create a macro button and place anywhere on my sheet? | Excel Discussion (Misc queries) |