Hey,

I have a spreadsheet containing charts that are linked to cell range
within the worksheet. (last four weeks of data).

Every week, we must go in and move the source forward one colum
manually.

Is there any way of doing this in VBA. I tried recording a macro an
moving it, but it assigns the new range to a literal location of cells
so it isn't repeatable.

Please help if you can.

Thanks,
Erik J. Lon

--
ErikLon
-----------------------------------------------------------------------
ErikLong's Profile: http://www.excelforum.com/member.php...fo&userid=3262
View this thread: http://www.excelforum.com/showthread.php?threadid=52431