Thread: xls vba find method to find row that contains the current date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default xls vba find method to find row that contains the current date
FindDate = "*" & Format$(Date, "m/dd/yyyy")
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"RCranston"
wrote in message
The find should get a match. I think I finally found the issue but not sure
best way to correct it. The FindDate is "03/26/2007" but the xls Date value
is showing up as "3/26/2007" and therefore no match. Any suggestions??
Thanks!
Reply With QuoteReply With Quote