=CELL("address") keeps changing

Hi,

When I use the CELL function, for each new cell I put the formula in, all previous cells w/ that formula update to the most recent reference.

e.g. If I put =CELL("address") in A2, it'll return '$A$2'. Though, if I then put the =CELL("address") in A3, it'll return '$A$3', but also change the value in A2 to '$A$3'.

How could I have the =CELL("address") formula in both A2 and A3, and get returned values of '$A$2' and '$A$3', respectively?

Thank you!

Hi,

Put:

=CELL("address",A2)

in A2 instead, and copy down as required.

Regards

It's returning the address of the last cell that changed.

See here halfway down the page

http://office.microsoft.com/en-gb/ex...010062392.aspx

Optional. The cell that you want information about. If omitted, the information specified in the info_type argument is returned for the last cell that was changed. If the reference argument is a range of cells, the CELL function returns the information for only the upper left cell of the range.

Syntax: CELL(info_type, [reference])

Reference is optional but is the cell you want information about. You're not providing it ...


Regards, TMS

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.