Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've googled n googled n searched but can not find the answer so I
thought I'd ask. Does Excel 97 or later have a "this cell" type reference ability? By this I mean the ability to do something like the following: If xy is an arbitrary cell address, then a formula like =OFFSET(<ThisCell,-1,0,1,1) stored in xy would resolve to =OFFSET(xy,-1,0,1,1), which incidently, is not circular. <ThisCell might have the form R[0]C[0], R*C*, A*1*, **, etc., assuming these notation are not used by Excel. Thanks, L Anderson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Enter an Excel cell reference as part of a custom header/footer | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |