Trying to copy non-contiguous blocks of cells is never easy. For example if
you select columns A and C (don't select B) and copy them and then try to
paste to a new worksheet, material gets pasted into A & B, not A & C. I
suggest that you:

1. copy with a series of contiguous copy/pastes to the second sheet
or
2. hide the columns you don't want to print and avoid copying at all
--
Gary's Student


" wrote:

I am trying to copy selected columns from ne shet to another to print
them using VBA in Excel. I have found that when you select multiple
ranges in Excel it seems that if you try to unselect one of the
selected columns you get another selected range. So if I select columns
A to D and columns E to H, I have 2 ranges. Then I try to unselect
column B ( in fact it doesn't unselect but jusr remains highlighted) as
I don't want it I get another range with just column B in. When I come
to copy the selected ranges I get col B twice. Is there a way round
this?
john