Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Joop,
thanks, that works!