Quote:
Originally Posted by KeriM
I'm trying to use Excel VBA to autocreate a chart title based on a cell value. This is what I've got so far:
Code:
.ChartTitle.Text = "Progress (as of " & "='OtherSheet'!R6C7" & ")"
It's supposed to say (as an example): Progress (as of August 28,2012)
The "August 28, 2012" is written in a cell in another sheet. I've tried double quotes, I've tried putting the = before the text and in the formula. The above code results everything written out as text, including the formula. It is just listing the formula as text, and it's not actually getting the value of that cell. Does anyone know the correct syntax to get this to work? |
Once again, I found a workaround; however, if someone knows how to get this working, I'm curious to know. I ended up just putting everything in another cell and then referring to that cell in my VBA.