Use Relative Reference in Developer Tab

Question

I need to record a macro, but my project is asking to make sure the Use Relative Reference option is NOT selected in developer tab. How do I know if it is selected, and how do I de-select?

Answer 1

Click on 'User Relative References'

Image below shows it NOT selected (Excel 2016)

Macro recorded when it is NOT selected

Sub Macro1()

'

' Macro1 Macro

'

'

    Range("B3").Select

    ActiveCell.FormulaR1C1 = "=SUM(R[-2]C:R[-1]C)"

    Range("B4").Select

End Sub

It is selected in the image below

Macro recoreded when it IS selected

Sub Macro2()

'

' Macro2 Macro

'

'

    ActiveCell.Offset(-1, 0).Range("A1").Select

    ActiveCell.FormulaR1C1 = "=SUM(R[-2]C:R[-1]C)"

    ActiveCell.Offset(1, 0).Range("A1").Select

End Sub

Answer 2

Christy,

re:  record a macro

In xl2010, the 'UseRelative References' button toggles on / off.  When "On" it is highlighted.

'---

Jim Cone

Portland, Oregon USA

https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)