xlVisibleCellsOnly Help to copy only Visible Cells/Rows
 

I am using Filters (in macros) to get different views of data.

I need to copy only the visible rows, Columns A to C and F.

When I copy the visible rows (the entire row), I get all the row
including the rows that are not visible.
-------------------
I'm eating fish and taking my vitamins but nothing is working!

Help Please?, Thanks, Craig

--
Craig
-----------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...fo&userid=2438
View this thread: http://www.excelforum.com/showthread.php?threadid=38387

xlVisibleCellsOnly Help to copy only Visible Cells/Rows
 

myrange.SpecialCells(xlCellTypeVisible).copy