Hi,
I'm trying to get only the row numbers from a filtered range. These row numbers should be stored in an array which will be used later in the code and should exclude the header row.
Below is the code that i tried out. There are 2 different types of msgbox statements which i tried (refer msgbox statements just before the end Sub statement) alternatively (by commenting one of them at a time).
rngVisible.Address gives me the entire filtered range
rngVisible.Row gives me the only one individual row number (1st row number in the filtered range)
![]()
Please Login or Register to view this content.
How to get only the visible row numbers and store them in an array??
Sample workbook attached.
Sarang
Bookmarks