hi,
i am filtering a listobject and passing some of its columns to a UDF called from a cell. the function is supposed to return only the filtered visible cells from those listcolumns. However it returns the whole range.
i have posted the details here:
excel - selecting SpecialCells(xlCellTypeVisible) from specific columns of ListObject table - Stack Overflow
can anyone help urgently?
i am filtering a listobject and passing some of its columns to a UDF called from a cell. the function is supposed to return only the filtered visible cells from those listcolumns. However it returns the whole range.
i have posted the details here:
excel - selecting SpecialCells(xlCellTypeVisible) from specific columns of ListObject table - Stack Overflow
can anyone help urgently?