Thread: prob with TODAY() within a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
deepika :excel help[_2_] deepika :excel help[_2_] is offline
external usenet poster
  
Posts: 45
Default prob with TODAY() within a macro
y this today() function is giving me an error when it is run within teh macro?
what should i include



Sub FTPmacro()

Cells(1, 10).value = TODAY() - Weekday(TODAY() + 1, 1) + 7

end sub

Reply With QuoteReply With Quote