Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel : Selecting Only Rows that are filtered 1
- Thread starter OzzieOwl
- Start date
-
1
- #2
Hi Martin,
This is the equivalent of Edit >> GoTo >> Special >> Visible Cells Only
To do this in VBA, select the range that contains the list (or replace the word "Selection" with a reference to the range), then use the following statement to copy only the visible (filtered) cells:
[tt]
Selection.SpecialCells(xlCellTypeVisible).Select
[tt]
Good luck, SteveB.
This is the equivalent of Edit >> GoTo >> Special >> Visible Cells Only
To do this in VBA, select the range that contains the list (or replace the word "Selection" with a reference to the range), then use the following statement to copy only the visible (filtered) cells:
[tt]
Selection.SpecialCells(xlCellTypeVisible).Select
[tt]
Good luck, SteveB.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Solved