Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Excel Macros
- Thread starter stecher
- Start date
- Sort by reaction score
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!
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!
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.
![Workbook1.png]( "Workbook1.png")
When this button is turned on, any Macro's created using the record button will use relative cell references.
