| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row number of filtered row
I need to get the row number of the second visible row in the current region.
The current region is filtered. Example If the current region starts at row 6, the second visible row is 28 because the current region is filtered. The following returns 7, because it not looking at visible rows only. I want the return value to be 28, the second VISIBLE row. Dim intRowNumber As Integer intRowNumber = ActiveCell.CurrentRegion.Rows(2).Row Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I 'count' the number of entrances in filtered cells? | Excel Worksheet Functions | |||
| How do I count the number of filtered rows | Excel Worksheet Functions | |||
| How to number rows after data has been filtered? | Excel Discussion (Misc queries) | |||
| number missing when filtered | Excel Discussion (Misc queries) | |||
| Is there a limit to the number of rows that can be filtered | Excel Worksheet Functions | |||
Threaded Mode
