VB Code:
  1. Sheets("Output1").Copy

Hi
I want to copy a worksheet called "output1" but only row 2 downwards to the "USED Range. Therefore skipping out row 1.

I then want to paste the contents in a template excel file called "Master" starting at cell A5.

I tried a loop copying eachcell in the used range in an array but its wayyyy to slow for something simple.

Please can somone advise the quickest method.

Cheers,

Boris.