Thread: TODAY MACRO
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stuart WJG[_2_] Stuart WJG[_2_] is offline
external usenet poster
 
Posts: 22
Default TODAY MACRO

I have been running this macro for the last 4 weeks with success until the
date changed to 01-Apr-08 when it started giving the error message below I
have checked the format of the date cells and they are ok. Any ideas why it
is not working

Macro is
Sub GOTOTOALL()
Range("D17:HO17").Find(Format(Now(), "dd-mmm-yy"), , xlValues).Select
End Sub

Error
Run Time error: "91"
Object variable or With block variable not set


Best regards

Stuart