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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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.

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.