| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell offset for filtered list
Hi all,
I would like to know the VBA code to move down a row in a filtered list. I use the ActiveCell.Offset (1,0) method but the cursor moved to a hidden (set by my filter) row. My current location is A1 (heading for first column). I tried lookup for SpecialCells, thinking this may have something to do with the solution I want. Not succeeding. :( Thanks for sharing your insights. David |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cell offset for filtered list
Maybe you could just come down a row and check to see if that row is visible.
If it is, then stop. If it's hidden, then come down and test again. wrote: Hi all, I would like to know the VBA code to move down a row in a filtered list. I use the ActiveCell.Offset (1,0) method but the cursor moved to a hidden (set by my filter) row. My current location is A1 (heading for first column). I tried lookup for SpecialCells, thinking this may have something to do with the solution I want. Not succeeding. :( Thanks for sharing your insights. David -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Randomly Select cell from filtered list | Excel Worksheet Functions | |||
| Can Offset() be used in Excel cell formulas when filtered (visible-only)? | Excel Discussion (Misc queries) | |||
| Offset on a Filtered List | Excel Worksheet Functions | |||
| How do I select the first cell of a filtered list? | Excel Worksheet Functions | |||
| ActiveCell.Offset on filtered data | Excel Programming | |||
Hybrid Mode
