Thread: Static Date and Time code problem
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default Static Date and Time code problem
Hi, Laura-
Sorry for the delayed response: endless meetings droning on.

Please try changing this line:
Target.Offset(0, 1) = Date And Time
....to this, and let me know how it works:
Target.Offset(0, 1).value = now()

Reply With QuoteReply With Quote