Pasting to disconnected ranges

  • Thread starter Thread starter Viggy
  • Start date Start date
V

Viggy

I have a 10x10 array that I want printed to 2 disconnected 10x5 ranges.
I have tried:
Range("A1:E10, G1:K10") = ArrayName

But instead of printing the first 5 columns in the first half of m
range, and the second 5 columns in the second half, the code prints th
first five columns in the first half, and then prints htem again in th
second half. Is there a simple way to set this up, so that the cod
automatically pastes the array correctly.

Thanks,
Vigg
 
Hi Viggy,

What your code does is actually normal behavior for Excel, as you tell it to
display twice the same array with only "visible" space for the first 5
columns in the target ranges.
Have you tried to paste the whole array to A1:J10 and set a page break
before column F? This should get your print job on two separate pages,
although it would not really split your array in two.

hth

Robin
 
Back
Top