Hi Paul

Can you show the formulae you are using, with a sample of the data?

--
Regards

Roger Govier


"PaulW" wrote in message
...
Cell B2 = Postcode Search

Cell C2 returns the first line of address from vlookup / indirect
address
stuff like that. i have one cell that looks up the line of the address
from
another workbook that feeds which address to pull up. All this based
on the
postcode entered.

if the active cell highlights C2 i wish for that full address to
appear, if
C3 is highlighted full address for that also etc etc.

I'm trying to avoid VBA as there is no real trigger for the macro.

I'll take a look at what your suggsting below and let you know!!

Thanks Roger.

"Roger Govier" wrote:

Hi Paul

in VBA yes, you can use
activecell.address
activecell.row
activecell.column

as a Worksheet formula
=ROW() will return the row number of the cell in which you type the
formula
=COLUMN() will return the column number

In a formula, I think you might be needing the Offset() function as
=CELL("address",C7), will return $C$7 but in that case, you have fed
it
the location, so therefore you know the address.
=CELL("address"OFFSET(A1,2,6) will also return $C$7

can you give an example of what you are trying to achieve?

--
Regards

Roger Govier


"PaulW" wrote in message
...
Is there a formula that returns the address / row / column of the
active cell?

So i can use this to produce different results based on the active
cell.

PaulW