I am trying to create a range with visible cells after filtering based on a criteria. But, facing some wierd problem with setting correct range with visible cells. Here is the code. Can anyone help to resolve this?
Here,Please Login or Register to view this content.
returns correct values. For example, for a particular filtered criteria, if there are 6 rows, it returns 42 (6 rows * 7 columns).Please Login or Register to view this content.
However,always returns 1 (header row), though there are 6 rows. How can this be fixed?Please Login or Register to view this content.
Bookmarks