View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jeffrey Marks Jeffrey Marks is offline
external usenet poster
 
Posts: 12
Default 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