pasting with hidden columns

Hi All,

Hopefully a fairly easy one (i have searched the forums).....

Sheet1 has info in column a, b, c, d, e.

I want to paste these value into sheet2 but sheet2 has columns b, d hidden.

The paste end up putting the values in the hidden columnss.

Is there a way of pasting a speacial so that the hidden columns are missed and i get the paste to go into columns a, c, e, f, g WITHOUT code???


**edited. meant columns not rows.



Thanks,

Spinkung.

Apparently its not possible, you should have blank columns in sheet1 i-e column B & D should be blank in sheet1. (you can hide blank columns)