Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a simple way for a cell formula to refer to its own cell?
I can get my own column by using =COLUMN(), I can get my own row by using =ROW(). How can I get my own CELL ? I like to use C1=OFFSET(C1,-1,0) as a cut/copy/paste/delete-safe formula which refers to the value immediately above the current cell. The only trouble is in discussing formulas with others. I cannot say "use =OFFSET(B44,-1,0)" without further saying that that formula will only work in cell B44. Is there an equivalent to =OFFSET(ME(),-1,0) ? I have tried =OFFSET(,-1,0) but that is a syntax error. The best I have yet come up with is the following: =INDIRECT(CONCATENATE("R",TEXT(ROW()-1,0),"C",TEXT(COLUMN(),0)),0) Can anyone do it better? Brian Herbert Withun |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Relative/Current Cell Reference in Hyperlinks | Excel Discussion (Misc queries) | |||
Relative cell reference | Excel Discussion (Misc queries) | |||
Macro to run relative to current selected cell | Excel Discussion (Misc queries) | |||
Relative Cell Reference [How To] | Excel Programming | |||
Relative Cell Reference | Excel Worksheet Functions |