How to create macro to go to certain date within excel sheet?
B Bernie Deitrick Feb 28, 2007 #2 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
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
