Actions on Sheet activationh with Variables

[#1]

Hello,

when activating a sheet I want to set some filters with variables. One variable works fine with =$(myVar), but for setting the filter with more variables I didn't get it working:

($(my1stVar)|$(my2ndVar)|...) or ("=$(my1stVar)"|"=$(my2ndVar)"|...) or = ($(my1stVar)|$(my2ndVar)|...) or =("$(my1stVar)"|"$(my2ndVar)"|...)

didn't work.

Anyone got a solution for this?

Thanks

Peter

[tresesco · Accepted solution]

Assuming your variables are having search string, try like:

='(' & $(var1)&'|'&$(var2)&'|'&$(var3)&'|'&......&')'

if your search strings have spaces in between, you have to take care of that by including double quotes.

[#3]

Joop,

thanks, that works!