Paste Visible Cells Only - Size and Shape Issue

[Ottsel]

I got my sorting issue resolved thanks to Joe4, but I'm facing a challenge where I cannot paste my selected array into the desired area I want my sorted data.

Currently after sorting my list to hide all the zero values and only show the data I need I copy visible cells only.

activesheet.range("C300:P350").specialCells(xlCelltypevisible).copy

Then I want to paste values into C61:P74

The data can change, but it'll never exceed row 74.

I have a lot of other data below row 74, so I'm not sure how to approach it.

I keep getting a Size and Shape error every time I attempt to paste.values.

This booklet is ancient, so using Excel2003.

Any help, tips or suggestions would be greatly appreciated!

 

[earthworm]

Check this thread

VBA to copy-paste visible cells only

Hello, I am using the undernoted code to copy data from one sheet to other but the code copies all rows and columns to the new sheet. I want to copy only visible cells, please help me modify the code. Sub Summarize() Range("A1:EB62").Select Selection.Copy Sheets("Print").Select...

www.mrexcel.com