| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I choose the rows that are filtered ?
Here is part of my macro
'' Formatting Alan with color Range("A1").Select Application.CutCopyMode = False ActiveWindow.DisplayGridlines = False Selection.AutoFilter Field:=1, Criteria1:="Alan" Selection.AutoFilter Field:=3, Criteria1:="=Alan" ''''''''''' why is the next line A2 ? Range("A2").Select ''''''''''' Above line could be A20, how do How do I choose the rows that are filtered |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to choose a certain amount of rows and have them ex | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| Filtered Visible Rows & VBA Non-Filtered Rows Displayed | Excel Programming | |||
| choose a cell anywhere and have filtered data appear there? Is there a way? | Excel Programming | |||
Threaded Mode
