Thread: Formula in Chart Title via Macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
shelfish shelfish is offline
external usenet poster
  
Posts: 39
Default Formula in Chart Title via Macro
N'mind!

I was making that way too dificult. Solution:

chtTitle = Range("'" & chartDataSheetName & "'!$AG$3").Value
....ChartTitle.Characters.Text = chtTitle

Feeling a bit dumb right now,
-S.

Reply With QuoteReply With Quote