Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Navigating through filtered cells
Hi,
I'd like to step through rows of a column of cells which are visible due to me setting a filter. I may want to assign values to empty cells based on the values of neighboring rows. Since the data is filtered, there may be many "behind-the-scenes" rows that are not shown to me. What are the VB navigation commands that I can use to step my way through each row and reference only the visible cells immediately above and below cells of interest? Thanks much, Reney |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Navigating between cells | Excel Discussion (Misc queries) | |||
Navigating in filtered rows | Excel Discussion (Misc queries) | |||
Navigating through Cells | Excel Discussion (Misc queries) | |||
Navigating a filtered list | Excel Programming | |||
Navigating cells in VBA | Excel Programming |