Problem with VBA code and Range
That did the trick! Thanks so much for the help. I'm using XL2007, but a friend (who still uses XL2003) was trying to help out, which is where the 2003 code might likely have come from.
If I wanted to customize the ChartTitle to the value in column D, would that just be:
..ChartTitle.Characters.Text = "=Sheets(shName).$D$" & i
I tried this, and got "shName$D$1" as the title.
Thanks!
Jeff
|