Macro Recorder Question

[Nalani]

When using the Recorder to help me, I get the following:

 Range("K15").Select
    ActiveCell.FormulaR1C1 = "=IF(R[3]C[-9]=RC[2],1,0)"
    Range("K16").Select

I do understand what the R1C1 is saying but -

I don't particually like the R1C1 annotation and would prefer to reference the actual cells when writing my code.

How can I (if possible) set the recorder so it will give me:

=IF(B18=M15,1,0)

 

[shg]

Unselect Use relative references

 

[chuckchuckit]

Try clicking the Office Button in the upper left of Excel, click Excel Options located on bottom of the popup page, click formulas, uncheck R1C1 reference style in "Working with formulas.

Chuck

 

[Nalani]

Thanks for the quick replies guys:

shg - I tried Both ways still the same thing

chuck - R1C1 is not checked

 

[chuckchuckit]

I try closing and reloading your Excel file and make sure R1C1 not checked. If still not working, perhaps re-booting computer and trying again. If still unchecked and bad, maybe Excel is corrupted??

Can't figure what else it might be...

 

[Nalani]

Reletive Reference Unchecked gives:

 ActiveCell.FormulaR1C1 = "=IF(R[3]C[-9]=RC[2],1,0)"
    Range("K16").Select

CHECKED gives:

ActiveCell.FormulaR1C1 = "=IF(R[3]C[-9]=RC[2],1,0)"
    ActiveCell.Offset(1, 0).Range("A1").Select

EDIT: I might add that the line where it says "A1".select - never happens.
All I did was record the formula and press enter, which brought the cursor down one row.

 

[Nalani]

I try closing and reloading your Excel file and make sure R1C1 not checked. If still not working, perhaps re-booting computer and trying again. If still unchecked and bad, maybe Excel is corrupted??

Can't figure what else it might be...

I did close and reopen the File. same thing.

I doubt that my Excel is corrpt.

 

[chuckchuckit]

Since you are using the macro recorder, how are you getting that formula into the macro?

Could you cut and paste the full macro the recorder generates here? Including Sub, End Sub.

Thanks.

 

[shg]

I apologize, Nalani, I misunderstood your question.

 

[chuckchuckit]

One of my customers just called, so gotta run for a few hours. I'll check back then as am curious about possible solution there.

Chuck