ExcelBanter - Get Address of Active Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Get Address of Active Cell (https://www.excelbanter.com/excel-discussion-misc-queries/131045-get-address-active-cell.html)

LarryL

Get Address of Active Cell

Is there a function to access the address of the Active Cell without having
to revert to Visual Basic?

Thank You

Jim Thomlinson

Get Address of Active Cell

Nope... VBA is the only way...
--
HTH...

Jim Thomlinson

"LarryL" wrote:

Is there a function to access the address of the Active Cell without having
to revert to Visual Basic?

Thank You

salah

Get Address of Active Cell

the function below should work..

=+CELL("address",A1)
_______________________
salah

"LarryL" wrote:

Is there a function to access the address of the Active Cell without having
to revert to Visual Basic?

Thank You

Dave Peterson

Get Address of Active Cell

Won't that always return $A$1?

The original poster could use:
=CELL("address")&text(rand(),";;;")
(that + isn't necessary)

But it could be one calculation behind.

salah wrote:

the function below should work..

=+CELL("address",A1)
_______________________
salah

"LarryL" wrote:

Is there a function to access the address of the Active Cell without having
to revert to Visual Basic?

Thank You

--

Dave Peterson

All times are GMT +1. The time now is 09:30 AM.