Paste into visible columns/cells only

Hello,

Fairly new to VBA... so need some help!

I want to restrict users to only paste values into the spread sheet. I found the below code from another thread and it works well.

However, the spread sheet contains a hidden column. So when copying/pasting a row from another workbook, I want to ignore the hidden column (in the destination sheet) and paste into the visible columns/cells only.

E.g.

Source: Copy A1:J1
Destination: Paste into A1:K1 (Column J is hidden)

Please Login or Register  to view this content.

I came across something called "xlCellTypeVisible", but not sure how to incorporate this into the above code.

Really appreciate your help!

Cheers,
VJ

Guys... anyone?