View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
altoonaPillarRock altoonaPillarRock is offline
external usenet poster
 
Posts: 4
Default Automatically moving a chart range at the beginning of the next month

How can I do this? I have a bunch of workbooks that chart Nov 03 thru Oct
04. At the beginning of December how would I update the range to Dec 03 to
Nov 04 in all of the workbooks?