| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtered rows not in code???
look in the vba help index for special cells visible
-- Don Guillett SalesAid Software "John" wrote in message ... I have a spreadsheet with thousands of rows that I frequently filter (autofilter). I then have some code that I would like to run just on the filtered(showing) rows that I am selecting... meaning if I have rows 2-10 selected but only rows 2 and 5 are showing due to my filter... how do I perform my code just on those two rows??? I was trying... If Selection.Rows.Count 1 Then For i = 0 To Selection.Rows.Count - 1 Step 1 but this would perform the operation on all the rows (i.e. 2-10) any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Code for Printing All Filtered Rows Separate | Excel Programming | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| Help!!! I have problem deleting 2500 rows of filtered rows | Excel Programming | |||
| Filtered Visible Rows & VBA Non-Filtered Rows Displayed | Excel Programming | |||
Threaded Mode
