Excel macro - Column Name to Column Number

[wwj]

Column Name to Column Number

Code: Select all

ColName = "C"
Range(ColName & 1).Column

a = Range("C" & 1).Column

[wwj]

A number to column letter.

Code: Select all

   a = Split(Cells(1, maxCol_out).Address(True, False), "$")(0)

http://stackoverflow.com/questions/1279 ... -to-letter

[wwj]

In the Excel spreadsheet, use the following:

Code: Select all

= COLUMN(B2)    -->  2
= COLUMN(i2)    -->  9

It is not for VBA macro code.