Posted to microsoft.public.excel.programming
|
|
MACRO TO UPDATE DATES !
Range("C4").Value = Range("C42").Value + 1
--
Regards,
Tom Ogilvy
"jay dean" wrote in message
...
In my Excel sheet the ranges C4:C10, C12:C18, C20:C26, C28:C34 and
C36:C42 contain dates in the usual successive order. For example, if
C4:C10 contain the dates 10/1/03 to 10/7/03, then C12:C18 will contain
the dates 10/8/03 to 10/14/03, C12:C18 will contain 10/15/03 to 10/21/03
and so on.
I need a macro that when executed will update the dates to start
over. For example, if the last date in the last range C36:C42 is
11/4/2003, then to start over C4:C10 will update as 11/5/03 to 11/11/03,
C12:C18 will update as 11/12/03 to 11/18/03 , and so on. I would
appreciate your assistance. Thank you !
Jay Dean
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
|