{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch 13 part 2 - C hapter 13 Pa rt 2 Using the R1C1 Reference...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 13: Part 2 – Using the R1C1 Reference Style in VBA Continue with the MacroPractice.xlsm file you created in a previous exercise. Change your cell reference style to R1C1 (you should be able to use one of your worksheet buttons). Objective : Record 3 macros that enter formulas into Excel cells. Compare the VBA code generated for each macro and note the difference in how the code is written for relative and absolute cell references for formulas and worksheet navigation steps. 1. Record one macro with the Relative Reference off. (The ranges will be identified by the absolute cell address.) a. On a worksheet in the new workbook, type a short list of number values into any column of a worksheet. b. With the Relative Reference toggled off, in a cell underneath the list of numbers, add a formula that sums the list. c. Wait until you record the next macro to view the VBA code for the macro you just recorded.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}