Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select the next row
How can I select the next row in a filtered condition? For example - I have a filter set that shows: Row 1& 2 (header rows) Row 4 - data row Row 10 - data row If I use Activecell.offset(1,0).select, I get row 3 I need to be able to select the next visible row (in this case row 4) in the same way that I can do it if I press the down arrow but I need to do it programmatically. Any ideas? Glen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select the next row
Hi Glen.
Try the following which was suggested by Tom Ogilvy: '============== Sub SelectNextVisible() Dim Rng As Range Set Rng = Range(ActiveCell.Offset(1), _ ActiveCell.Offset(1).End(xlDown)). _ SpecialCells(xlVisible) Rng(1).Select End Sub '<<============== --- Regards, Norman "Glen Mettler" wrote in message ... How can I select the next row in a filtered condition? For example - I have a filter set that shows: Row 1& 2 (header rows) Row 4 - data row Row 10 - data row If I use Activecell.offset(1,0).select, I get row 3 I need to be able to select the next visible row (in this case row 4) in the same way that I can do it if I press the down arrow but I need to do it programmatically. Any ideas? Glen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Select other workbook to select data in a macro. | Excel Programming |