Paste into range with hidden columns
 

I have data in columns A:Z on Sheet 1. I need to copy/paste this data onto
Sheet 2, but the range I want to Paste over has multiple hidden columns
(calculations) that I want to 'skip over' so they remain intact. In other
words, I want to paste into the 'visible' columns on Sheet 2. Is there any
way to do this? I thought perhaps I could use the Goto...Special...Visible
Cells when I do the Paste process, this doesn't seem to work.