Last Used Column Name in A row

[ankita.sethi]

Hi
I am pretty new in VBA. I am trying to find out how to find the name of the last column in a row (say row 1).
I tried using:

LCol = Range("A1").End(xlToRight).Column

But this returns the 'number' of the last cell in that row.
For example, if the last cell is G1 in the first row, I want "G" instead of "7".

Any help will be appreciated.

Thanks,
Ankita

 

[Richard Schollar]

Hi

The column letter? eg:

LCol = Split(Range("A1").End(xlToRight).Address(True,False),"$")(0)

 

[sijpie]

http://www.mrexcel.com/forum/showthread.php?t=71978
http://www.ozgrid.com/forum/showthread.php?t=42740&page=1
http://www.ozgrid.com/forum/showthread.php?t=65441&page=1