Go Back   MacRumors Forums > Apple Systems and Services > Mac Basics and Help

Reply
 
Thread Tools Search this Thread Display Modes
Old Feb 22, 2013, 01: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, 10:20 AM   #2
blevins321
macrumors 68030
 
Join Date: Dec 2010
Location: Winnipeg MB
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 15" Retina MBP; iPhone 5S; iPad Air
blevins321 is offline   0 Reply With Quote
Old Feb 24, 2013, 10: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:	26
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

Similar Threads
thread Thread Starter Forum Replies Last Post
Excel file (macros) works on windows computer but not on virtual machine on mac thtw Windows, Linux & Others on the Mac 0 May 4, 2014 09:27 AM
Visual Basic Module/Macro works in Windows Excel but not Mac Excel 2011 chrispy1042 Mac Applications and Mac App Store 2 May 4, 2014 08:41 AM
Templates for Microsoft Excel - Best Excel Spreadsheets for Mac! Alexander-James Mac Applications and Mac App Store 1 Apr 24, 2014 02:19 AM
Formulas in Excel on Mac... Switch to values in Excel on PC Noob2mac Mac Applications and Mac App Store 2 Apr 24, 2013 06:24 AM
Creating Pivots in Excel 2011 that can be used in Excel 2003 (Windows) Extreme Red Mac Applications and Mac App Store 2 Jun 5, 2012 10:51 AM

Forum Jump

All times are GMT -5. The time now is 02:44 AM.

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

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