Relative Cell Reference [How To]

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 23 Sep 2006 01:02 GMT

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 to this Message

JLGWhiz - 23 Sep 2006 02:19 GMT

This site might be of help:
http://www.bettersolutions.com/excel/EED883/VC418316331.htm

> In VBA I can do a relative cell reference from the currently selected cell by
> using...
[quoted text clipped - 3 lines]
> Thanks,
> Rob

Reply to this Message

Rob - 23 Sep 2006 02:43 GMT

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

> This site might be of help:
> http://www.bettersolutions.com/excel/EED883/VC418316331.htm
[quoted text clipped - 6 lines]
> > Thanks,
> > Rob

Reply to this Message