Macro using Chr function to select double-lettered columns

[jackyung]

Dear all,

I want to use Chr function to select multiple columns as the coding contains variable. However, if the column is double-lettered column, the coding would have error.

For example:

temp = 22
Columns(Chr(64 + temp + 3) & ":" & Chr(64 + temp + 4)).Select

Column Y and Z will be selected.

temp = 23
Columns(Chr(64 + temp + 3) & ":" & Chr(64 + temp + 4)).Select

Supposed Column Z and AA will be selected. However as Chr(91) is not AA so the coding would have error.

How can I prevent this error? Or is there any other coding instead of using Chr function to get the same result? Thanks.

Jack

[salim ali]

try this example,
you can choose the values of temp and x

Please Login or Register  to view this content.

Or For many specific selection

Please Login or Register  to view this content.

[Akuini]

Try this:

Please Login or Register  to view this content.

Edit: Sorry, it is easier like this:

Please Login or Register  to view this content.

[jackyung]

Hi all,

Thanks for the coding. It works perfectly. Really appreciate!

Jack