Selecting Columns

Hi

How can I select columns by reference

Suppose I want to select Columns F I and K

Please Login or Register  to view this content.

This works but can it be done by reference using maybe Cells(7,1)
or something like that? I tried using Range(Cells(x,x),Cells(y,y),Cells(z,z)) but that is not working. Any ideas?


Thanks

Hello Dohko,

You need to use the union method.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello Dohko,

You need to use the union method.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Using Leith above you could also use:

Please Login or Register  to view this content.

mccreaso

How to select a particular cell like A1,B1,C1......etc


Thanks
Sathis

Originally Posted by sathis

This works but can it be done by reference using maybe Cells(7,1)
or something like that? I tried using Range(Cells(x,x),Cells(y,y),Cells(z,z)) but that is not working. Any ideas?

How to select a particular cell like A1,B1,C1......etc


Thanks
Sathis