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