|Feb 24, 2013, 09:20 AM||#2|
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.
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
|Thread Tools||Search this Thread|
|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 08: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 07:41 AM|
|Templates for Microsoft Excel - Best Excel Spreadsheets for Mac!||Alexander-James||Mac Applications and Mac App Store||1||Apr 24, 2014 01: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 05: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 09:51 AM|
All times are GMT -5. The time now is 04:59 AM.