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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Navigating through filtered cells
Have a look
Sub Macro2() Set Rg = Selection.CurrentRegion.SpecialCells(xlCellTypeVis ible) For Each Cell In Rg If Intersect(Cell.Offset(1, 1), Rg) Is Nothing Then ''''Exit Sub Else Cell.Offset(1, 1).Select End If Next End Sub --- Message posted from http://www.ExcelForum.com/ |
Reply |
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 |