Hi,

I need a one time solution to this problem, does'nt have to be elegant or
repeatable!:
I need to be able to change the sheet part of the chart source property
whilst not touching the cell references, which are currently correct.

My ideal solution is: to have a macro open up the chart and perform a 'find
and replace' action on the sheet source, leaving the whoel rest of the string
alone.


I am new to programming excel (though have a little exp in Access), so if
you DO have any suggestions please make them self explanatory!


Thanks in advance