Formula appears as =RC[-3]+RC[-1] Whats this?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting formula formatted as =RC[-3]+RC[-1] when simple Row and Column
references is what I desire to see. I don't know how to interpret the formula
as shown when I select that cell. I type in the typical Row/Cell location but
it gets displayed as above. an anyone help????
 
Tools>Options>General>R1C1 Reference Style, uncheck it

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro autofills formula when a cell value is changed 4
Formula in macro gives "Run-time error '1004':" 1
Use a Variable in a formula 4
Why does the Formula in VBA not calculate 3
COPY BY MACRO DOWN TO LAST VALUE CELL IN COLUMN "A" 1
Insert Formula in cells from VBA 2
Combine 2 columns in a dynamic range into one 7
Autofill is overwriting the column title..... 4

Back
Top