Thread: Date "E2" to add 7 days How?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
  
Posts: 276
Default Date "E2" to add 7 days How?
Never mind worked it out.

activecell.FormulaR1C1 = [E2] + 7


Regards

Corey


Reply With QuoteReply With Quote