| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative Cell Reference [How To]
In VBA I can do a relative cell reference from the currently selected cell by
using... R[2]C[-4] .... How do I achive the same thing within a formula? Thanks, Rob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Relative Cell Reference [How To]
This site might be of help:
http://www.bettersolutions.com/excel...C418316331.htm "Rob" wrote: In VBA I can do a relative cell reference from the currently selected cell by using... R[2]C[-4] ... How do I achive the same thing within a formula? Thanks, Rob |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Relative Cell Reference [How To]
No help what-so-ever. What I'm looking for is something along the lines of...
Formula in cell C4 =IF(ROWS(9)+COLUMNS(-2)="TOOTSIE","BEE-ATCH","YUCK FOU") Does that help? Thanks, Rob "JLGWhiz" wrote: This site might be of help: http://www.bettersolutions.com/excel...C418316331.htm "Rob" wrote: In VBA I can do a relative cell reference from the currently selected cell by using... R[2]C[-4] ... How do I achive the same thing within a formula? Thanks, Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup & relative cell reference? | Excel Worksheet Functions | |||
| Macro relative cell reference | Excel Worksheet Functions | |||
| Relative cell reference | Excel Discussion (Misc queries) | |||
| Relative Cell Reference | Excel Worksheet Functions | |||
| How do I set up a macro using relative cell reference? | Excel Programming | |||
Hybrid Mode
