G
Guest
Hi All,
Ok I am using the Range command to select multiple columns like this..
Range("A:A,B:B,C:C,F:F,AB:AB,AC:AC,BF:BF").Select
The problem I am having is my actual range of columns includes many more
columns that the example above.
Is there a maximum to how man columns you can include to select with the
range command ?
because the range command fails when I get to man coluns listed like say 200
or more.
Is there another way to accomplish this ? because all I realy want to do is
have vba do the same thing as if I manual selected up to 200 columns with the
mouse while holding down the Ctrl button.
Ok I am using the Range command to select multiple columns like this..
Range("A:A,B:B,C:C,F:F,AB:AB,AC:AC,BF:BF").Select
The problem I am having is my actual range of columns includes many more
columns that the example above.
Is there a maximum to how man columns you can include to select with the
range command ?
because the range command fails when I get to man coluns listed like say 200
or more.
Is there another way to accomplish this ? because all I realy want to do is
have vba do the same thing as if I manual selected up to 200 columns with the
mouse while holding down the Ctrl button.