Offset function and references

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
ActiveCell

--

HTH

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

Niklas said:
Hi
The synrtax is OFFSET(reference,rows,cols,height,width). How do I refernce
Click to expand...
the cell where the function is written in? I am looking after a "Me"
functionality.
 
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


Niklas said:
Hi
The synrtax is OFFSET(reference,rows,cols,height,width). How do I refernce
Click to expand...
the cell where the function is written in? I am looking after a "Me"
functionality.
 
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
 
Back
Top