I need to copy a specific number of cells after apply a filter.
In my case, I need to copy the first 10 visible rows.
I tried with Range(Range("A5"), ActiveCell.Offset(10,3)).Select but not works, that copy hidden rows...
Thanks
Asked
Active
Viewed 514 times
0
-
Possible duplicate of [Copy/Paste/Calculate Visible Cells from One Column of a Filtered Table](http://stackoverflow.com/questions/17531128/copy-paste-calculate-visible-cells-from-one-column-of-a-filtered-table) – Ralph May 17 '17 at 07:36
-
Thanks, but I need to copy just the first visible 10 rows – Zunzunm3 May 17 '17 at 07:39
-
Iterate on Range.SpecialCells(xlCellTypeVisible).Rows, count to 10 adding each row to a new range that will contain the 10 rows. – jivko May 17 '17 at 08:46
-
Ok, I'll try and comment. – Zunzunm3 May 17 '17 at 11:25
-
jivko, could you show me an example? Thanks – Zunzunm3 May 17 '17 at 15:31