S

#### spectrallypure

It seems that from one day to the next I am suddenly in the need of

performing odd things using VBA.This time I need to get the current

formula on a chart's title. I'll proceed to explain a little bit why I

am needing this so badly.

I have a sheet with tons of charts whose titles contain formulas that

point to the actual cells containing the title strings, which in turn

are formed by means of intricate text concatenations. I need to reuse

all these charts in many other sheets. Unluckily enough, when one uses

formulas in chart titles it's impossible not to include the sheet

references in them (i.e. titles' formulas inevitably have references

in the format "sheet_name!cell"). Thus, when I copy all these charts

to any another sheet, they all bear the references to the old sheet.

Therefore, all the copied charts need to have their titles updated.

To summarize, I need to figure out some VBA code to process all these

charts and update the formulas on their titles to point to the correct

sheet names. The problem is that I have not been able to find out how

to get (using VBA) the current formula on a chart's title. Using the

macro recorder doesn't help at all (it seems to have a "depth" limit

on the operations it records -for instance, it can't even record the

procedure of adding a formula in the title on a chart!).

Well, I guess that's it. Please let me know if you have any ideas on

how to accomplish this. ...even any comments on the feasibilty of my

intended solution are pretty much welcome!

Thanks in advance for any help!

Jorge Luis.