ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to create macro to go to certain date within excel sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/132700-how-create-macro-go-certain-date-within-excel-sheet.html)

Mohamed

How to create macro to go to certain date within excel sheet?
 
How to create macro to go to certain date within excel sheet?

Bernie Deitrick

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?





All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com