Offset function and references

[Niklas]

H
The synrtax is OFFSET(reference,rows,cols,height,width). How do I refernce the cell where the function is written in? I am looking after a "Me" functionality
Regard
/Niklas

 

[Bob Phillips]

ActiveCell

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi
The synrtax is OFFSET(reference,rows,cols,height,width). How do I refernce

the cell where the function is written in? I am looking after a "Me"
functionality.

 

[Frank Kabel]

Hi
one way:
=ADDRESS(row(),column())

 

[Arvi Laanemets]

Hi

Pe. when the formula is entered into cell A1, and it must return the value
from cell B2
=OFFSET(A1,1,1)
With relative references, the base cell is adjusted automatically when
formula is copied.


--
(When sending e-mail, use address (e-mail address removed))
Arvi Laanemets

Hi
The synrtax is OFFSET(reference,rows,cols,height,width). How do I refernce

the cell where the function is written in? I am looking after a "Me"
functionality.

 

[Niklas]

H
I can not get it working. If I use the ADRESS function in a cell it works, but if I use as an in-argument to the OFFSET function I get a syntax error
Regard
/Nikla

----- Frank Kabel wrote: ----

H
one way
=ADDRESS(row(),column()

--
Regard
Frank Kabe
Frankfurt, German

Niklas wrote

 

[Frank Kabel]

Hi
try
=OFFSET(INDIRECT(ADDRESS(row(),column())),1,0)