Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Feb 22, 2013, 12:09 PM   #1
stecher
macrumors newbie
 
Join Date: Feb 2013
Excel Macros

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
stecher is offline   0 Reply With Quote
Old Feb 24, 2013, 09:20 AM   #2
blevins321
macrumors 68030
 
Join Date: Dec 2010
Location: Detroit Area
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!
__________________
Late 2013 iMac; iPad Air; iPhone 5S; Synology NAS
blevins321 is offline   0 Reply With Quote
Old Feb 24, 2013, 09:33 AM   #3
James Craner
macrumors 68000
 
James Craner's Avatar
 
Join Date: Sep 2002
Location: Bristol, UK
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.

Click image for larger version

Name:	Workbook1.png
Views:	6
Size:	132.3 KB
ID:	399097
__________________
Productivity Orchard Be more productive with your Mac
James Craner is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 06:33 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC