| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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. (E-Mail Removed) 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 |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Offset on a Filtered List | ryguy7272 | Microsoft Excel Worksheet Functions | 6 | 19th Apr 2012 05:00 PM |
| Randomly Select cell from filtered list | Matt Ferguson | Microsoft Excel Worksheet Functions | 1 | 26th Nov 2009 02:12 AM |
| Can Offset() be used in Excel cell formulas when filtered (visible-only)? | EagleOne@discussions.microsoft.com | Microsoft Excel Misc | 0 | 19th Jul 2008 04:35 PM |
| get cell value where offset cell = X, use this value to populate list | CJ | Microsoft Excel Programming | 8 | 22nd Apr 2008 08:59 PM |
| How do I select the first cell of a filtered list? | Shane Moore | Microsoft Excel Worksheet Functions | 2 | 15th Aug 2006 02:18 PM |
