Hi,

I have 10 identical sheets in a workbook. I have a copy of th
workbook to which i would like to paste certain non-contiguous cell
from the original workbook.

so i would need to loop through all 10 sheets in workbook 1 and cop
certain cells to workbook 2

Can anyone give me a pointer on how to do this using VBA?

Do I need to copy and paste each range seperately or can i use th
union method to create the complete range of cells in each sheet that
wish to copy?

Thanks

F

--
Frigid_Digi
-----------------------------------------------------------------------
Frigid_Digit's Profile: http://www.excelforum.com/member.php...fo&userid=2692
View this thread: http://www.excelforum.com/showthread.php?threadid=40188