intelligent paste of address()

[yky]

Anyway to paste address() so the reference will change according to the cell location?

Now, if A1 contains the formula "=address(2,2)", no matter which cell I paste the formula to, the cell will always contain the formula "=address(2,2)". The formula will not change regardless the cell location.

Is it possible to paste the formula to, say, A2 and A2 will contain the formula "=address(2,3)"?

 

[Richard Schollar]

Try:

=ADDRESS(2,ROW()+1)