Excel Macros

[stecher]

I don't know how to tell the macro recorder to use relative cell position rather than fixed. Anybody know where I should look?

Mike

[blevins321]

I don't know if there's an automated way to do that besides recording a formula being entered to convert to the row/column relative format. But you can manually code it.

Range("A1").Value ="Something"

Can turn into Cells(row#,col#) = "Something". You can do math inside there so if you want three rows over and one cell down you could do Cells(row() + 3, col# - 1) = "Something".

Hope that helps!

[James Craner]

Mike, There is a relative reference button in the Developer Ribbon - See screenshot.

When this button is turned on, any Macro's created using the record button will use relative cell references.