Return the address of cell table

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

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


---
Regards,
Norman



"0-0 Wai Wai ^-^" <x@x.com> wrote in message
news:OJ1EfRXoFHA.4012@TK2MSFTNGP09.phx.gbl...
>
> 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" <normanjones@whereforartthou.com> ¦b¶l¥ó
news:uAa925XoFHA.3300@TK2MSFTNGP15.phx.gbl ¤¤¼¶¼g...
> 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.