Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
wnorwood
Contributor III
Contributor III

Variable for Sheet Object

Hello,

I think this is an easy one...

I have a macro that creates a couple of charts.  I am trying to create a function for the chart creation since most of the actions are the same.  My question is how do I send a variable to be used as the chart object name.

For example, I want the "CH04" in the statement below to be sourced from a variable.

set chart = ActiveDocument.GetSheetObject("CH04")

Thanks.

Labels (1)
1 Reply
wnorwood
Contributor III
Contributor III
Author

Nevermind.... I was using the letter O instead of the number 0.  Sorry to have bothered you.