Referring to a Range of Columns

[Guest]

Greetings to all

How can I select a range of columns with column index? I used Columns ("2:7").select, but it is not working.
Only Columns ("B:H").Select will work. If I convert index number to alpha, how can I convert beyond Z or z, like AA, AB...? Thanks.

 

[Ian Ripsher]

ThisWorkbook.ActiveSheet.Range(Columns(2), Columns(4)).Select
will select the range comprising columns 2 to 4, i.e. columns 2, 3 & 4 (=
columns B, C & D)

Greetings to all!

How can I select a range of columns with column index? I used Columns

("2:7").select, but it is not working.

Only Columns ("B:H").Select will work. If I convert index number to alpha,

how can I convert beyond Z or z, like AA, AB...? Thanks.

 

[Frank Kabel]

Hi
try
Range(columns(2),columns(4)).select

 

[Guest]

Thank you so much for your help, Ian and Frank. I do appreicate that.