View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default how do I use r1c1 notation in excel? just doing "=r2c3" not work

If you are entering it into a cell in 2003, you need to set the options
correctly.

It's Tools - Options - General

Check R1C1 reference style.

If that's not the problem, let me know.
--
HTH,
Barb Reinhardt



"sma" wrote:

I need to use r1c1-style in excel formula.
when I do for example "=r2c3", excel reports an error. How do I use r1c1
style in formula?

thanks,