Return the address of cell table

  • Thread starter Thread starter 0-0 Wai Wai ^-^
  • Start date Start date
0

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
 
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
 
Norman Jones said:
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
Click to expand...

???
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.
 
Back
Top