Below is the code. According to scores of articles, CopyRange.SpecialCells(xlCellTypeVisible).Copy followed by DestinationRange.PasteSpecial should only copy the visible rows. However it copies ALL the rows.
All the work-around articles say, NO PROBLEM - just loop through EACH row of data.
Is there a way to copy ONLY the visible rows as a range?
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
I found the solution. You must pastespecial xlpastevalues or it won't work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks