Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Phillips,
In the past, when I used auto filter and cut and paste, it moved all rows in between (even hidden) and I don't want this to happen! I would prefer, not to mess with filters, as sometimes, I do have some funky and complicated filters inpalce. But. I can live with that, if I can figure out how to prevent the hidden rows from being moved. Use something like this: Dim oRange As Range Set oRange = ActiveSheet.Range("A1:F2000") 'or whatever your filtered range is oRange.Cells.SpecialCells(xlCellTypeVisible).Copy 'now paste somewhere Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving rows with multiple criteria | Excel Worksheet Functions | |||
Moving cells based on certain criteria | Excel Discussion (Misc queries) | |||
Moving Rows to another sheet based on an entry | Excel Worksheet Functions | |||
Moving rows from one sheet to another based on a particular cell v | Excel Discussion (Misc queries) | |||
Sum based on criteria in rows and columns | Excel Discussion (Misc queries) |