MS Excel: Name Box Reference

[June1975]

Hi - Does anyone kno whow to obtain the name box value reference through VBA Excel.

For example if I click in the cell Row 6, Column C the name box in Excel displays as "C6". How to I get this value programatically? Is there a cell property or application function that does this for me?......

 

[SkipVought]

Hi,

ActiveCell.Address

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}