Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I have variable(s) that is: per sheet?

I want to set a variable linked to sheet. - is that possible?

example:

variable: vMyvar has value 'A' on sheet1, but value 'B' on sheet2

11 Replies
Not applicable
Author

Remya . I can not even remotely see how this could help me  ....sorry

- please put my example in context with your response.

Not applicable
Author

My question must have been unclear indeed :-), I am not trying to show/hide sheets, I'am trying to

populate a variable that is per sheet and not global (as they are by default to my understanding.)

example again;

variable vMyvar = 'adam' on sheet1 - but on sheet2 same variable (or to be correct a variable with the same name) has value 'eve' assigned.