Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
JimThieser
Posted - 06/16/2021 : 04:00:58 AM Origin Ver. and Service Release (Select Help-->About Origin): Operating System: Hi, I would like to scan a column for the existing names in this and then i would like to use the names for filter option. So i don't know how save each name as variable...
Do you have any ideas?
Thanks
1 L A T E S T R E P L I E S (Newest First)
YimingChen
Posted - 06/16/2021 : 10:37:21 AM Try the script close to:
string aa = cell(1,1)$;
wks.col2.filter = 1;
wks.col2.filter$ = x = "%(aa$)";
wks.runfilter();