How to derive Column Name of the active cell [SOLVED]

[ThrottleWorks]

Hi,

I want to derive column header of the active cell, for example if the active cell if A1 I want to populate value as A. if active cell is B2 value returned should be B.

I tried Google search, but could not find.

Can anyone please help me in this.

PS - Solved, copied answer from below link.

http://www.vbaexpress.com/forum/showthread.php?6103-Solved-get-column-letter