View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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