S
Szabó László
Guest
I have some issue about Autofilter a range of cells on an Excel sheet.
the part of the code: vchWorkSheet:Range(XLS_col(1) + STRING(2) + ":" + XLS_col(vi_x) + STRING(2)):Autofilter.
where: vchWorkSheet - the actual worksheet Range(XLS_col(1) + STRING(2) + ":" + XLS_col(vi_x) + STRING(2)) - the range of cells
I've got an error message when building app: "Wrong number of parameters. Component method Autofilter called with < 3 parameters."
Actually I would like to use only VisibleDropDown parameter, nothing to filter in default.
Error message here
Any idea?
I've tried to add some parameters, but i don't know the syntax of Autofilter arguments.
I would like to display filter option on the range
Continue reading...
the part of the code: vchWorkSheet:Range(XLS_col(1) + STRING(2) + ":" + XLS_col(vi_x) + STRING(2)):Autofilter.
where: vchWorkSheet - the actual worksheet Range(XLS_col(1) + STRING(2) + ":" + XLS_col(vi_x) + STRING(2)) - the range of cells
I've got an error message when building app: "Wrong number of parameters. Component method Autofilter called with < 3 parameters."
Actually I would like to use only VisibleDropDown parameter, nothing to filter in default.
Error message here
Any idea?
I've tried to add some parameters, but i don't know the syntax of Autofilter arguments.
I would like to display filter option on the range
Continue reading...