Excel Forum
Similar Content
Change Formulas to Absolute or Relative References
Macro: This macro will change the formulas in cells to absolute or relative. It allows you to cha...
Make Your Macros Available in All Workbooks in Excel
Tutorial: In Excel, you can make it so all of your macros can be easily accessed by any Excel workb...
Highlight and Sort the Top and Bottom Performers in a List in Excel
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allow...

Highline Excel Class 53: Relative & Absolute Macro Recorder

Learn about:
1.Relative & Absolute button in the Developer Ribbon
2.The fact that the Relative & Absolute button governs selection movement when recording a Macro
3.The fact that the cell references in Formulas created during a Recorded Macro are governed by the dollar signs
4.When to record an Absolute Marco
5.When to record an Relative Marco
6.When to Record a Relative & Absolute Macro
7.How to create a formula during a recorded Macro that will pick up a variable number of cells
8.How to trick the Absolute Macro into recording a Relative Movement using keyboard shortcuts
9.A Macro for formatting a report and adding a column of formulas for a static range of data
10.A Macro for taking data in columns and moving it to a row
11.A Macro for formatting a report and adding a column of formulas for a variable range of data
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Got a Question? Ask it Here in the Forum.