Paste to only visible columns

J

JTF

Want to copy and paste data from one worksheet to another. The
worksheet that we will paste TO has hidden columns. The worksheet we
are pasting FROM does not have hidden columns. HOw can we paste the
data to ONLY the visible columns in the recieiving worksheet?

I hope I explained this so it makes sense. Many thanks.
 
D

Debra Dalgleish

You can't paste into visible columns only. Perhaps you could rearrange
the columns so the hidden columns aren't in the paste range.
 
J

JTF

Thanks Debra. We have considered that, but if we do that, the column
letters will change and we have a VB routine that references the column
letters. I wanted to avoid having to re-do that whole thing, but it
looks like I may have no choice.

Thanks again.
 
Top