Return the address of cell table

[0-0 Wai Wai ^-^]

Hi.
Eg: I have a table (cell ref = A5:B10).

Is there any formula which can call the cell reference of the table?
So the code will be something like:
=[display the cell reference of the table]

===============
I use:
- Win XP
- Office XP

 

[Norman Jones]

Hi 0-0 Wai Wai ^-^,

If you refer to VBA, then perhaps:

Range("A5").CurrentRegion.Address

Or, with any table cell selected:

ActiveCell.CurrentRegion.Address

 

[0-0 Wai Wai ^-^]

Hi 0-0 Wai Wai ^-^,

If you refer to VBA, then perhaps:

Range("A5").CurrentRegion.Address

Or, with any table cell selected:

ActiveCell.CurrentRegion.Address

???
Is it the only way to call a cell reference?
If there's a formula avaiable that can call the cell reference, it would be
great.