5 replies
by dklippert
When you record the macro, you can click the Relative Address button just to the right of the Stop button on the Record macro toolbar. This will toggle between Absolute and Relative addressing.
Sub AddaRow
Selection.EntireRow.Insert
End Sub
by shanghai sam
by dklippert
When you are recording a macro, you dont use the F4 key. Start the macro recorder. This from the Help file:
"If you want the macro to run relative to the position of the active cell, record it using relative cell references button. On the Stop Recording toolbar, click Relative Reference (just to the right of the Stop button) so that it is selected. Excel will continue to record macros with relative references until you quit Excel or until you click Relative Reference again, so that it is not selected."
by bholt
by bholt
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending