View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Delboy Delboy is offline
external usenet poster
 
Posts: 17
Default Array to copy from one workbook to another

Hi,

I have an array (and For next loop) which copies specified (by me) named
sheets from a user selected workbook. The bit that I can't get to work is
how do I select the same named sheets from the original array in the "master"
workbook to receive the paste? They need to be selected individually as
there are a series of different ranges being pasted etc. Help.