Excel Macro VBA Tip 18 - Easily Make R1C1 References for Large Array Formulas Using Macro Recorder

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn a neat trick to put R1C1 style cell references into an Array formula in Excel. This tutorial shows you a trick to change a completed array formula in excel from A1 style cell references to R1C1 style cell references using the Macro Recorder. This is a huge time saver and is needed because when you use a macro to enter a large array formula into a cell from a macro, you need to be using R1C1 style cell references. If you use arrays a lot and need to make R1C1 style cell references, then this tutorial is for you.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• r1c1
• a1
• cell references
• macros in excel
• macro recorder
• record a macro
• excel
• array formulas
• vba
• visual basic

[paddydive]

hi i want to know every time i use R1C1 formula it is giving me a Absolute reference in excel... what if i do not want absolute references in my formula