Thread: code that searches for current date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default code that searches for current date
Range("F:F").Find(Format(Now(), Range("F2").NumberFormat), , xlValues).Select

This assumes that the formatting is consistent down column F, and F2 contains a date...

HTH,
Bernie
MS Excel MVP


"J.W. Aldridge" wrote in message
ups.com...
tyring to get a code that searches column F for the very first
instance of the current date (i.e. 10/3) and stops on that cell



Reply With QuoteReply With Quote