Paste Special in a Variable Column
 

I have two sheets. What I want to do is take the values from the firs
sheet and paste them into the second sheet in the correct column.

I have a Integer variable already set up that contains the column
that the data needs to be pasted in

--
MABeatt
-----------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...fo&userid=3225
View this thread: http://www.excelforum.com/showthread.php?threadid=52575