Refer to column as AA rather than column 26

[mark hansen]

I'm using a Select Case statements with the Select Case ActiveCell.Column to get the number. The each case has the number to have that code take effect.

Is there a way to allow me to use the Case statements such as CASE "AA".

Its not hard to get the column number, but it would be easier to use column header label rather than the column number. It would also make the code easier to read.

 

[Rick Rothstein]

I'm using a Select Case statements with the Select Case ActiveCell.Column to get the number. The each case has the number to have that code take effect.

Is there a way to allow me to use the Case statements such as CASE "AA".

Try this as your Select Case statement...

Select Case ActiveCell.EntireColumn.Address(0, 0)

Then your Case statement could be this...

Case "A:A"

 

[mark hansen]

Thanks for the quick reply Rick, that helps a lot. It will allow me and others to read and under the code easier and add additional Case statements when we need to expand to additional rows.