Copy/Paste area not the same

[paquirl]

When some rows are hidden, and you copy a column, then try to paste values, it gives error msg copy and paste area not the same. Is there a way around this without VBA programming?

 

[Sufiyan97]

When you select entire column and copy

and try to paste it in selecting particular cell it will give you the above error message

but in real you can not paste on visible cells only while you have some hidden rows.

 

[Sufiyan97]

If you post some sample of data, I might help you for what you are trying to do