Chapter 35 - Activecell Macros in this Workbook...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Activecell Macros in this Workbook ActivecellDemo() ActivecellDemo1() Placing the cursor on a cell with a small red triangle in the corner will show you the source code of the Macro or Function To edit the code you may press [Alt-F11] and look for a module called Chapter. The Macro or Function should be in it. A B C D E F G H I J 1 2 3 4 5 MeanReturn in Action 100.000 ### <-- =meanreturn(A3:A8) 110.000 ### <-- =meanreturn(A3:A5) 121.000 ### <-- =meanreturn(A5:A8) 145.200 174.240 209.088 Placing the cursor on a cell with a small red triangle in the corner will show you the source code of the Macro or Function To edit the code you may press [Alt-F11] and look for a module called Chapter. The Macro or Function should be in it. A B C D E F G H I J K L 1 2 3 4 5 6 7 8 TwoLeftThreeDown in Action 8 <-- =3+5 ### <-- =TwoLeftThreeDown(A1) Placing the cursor on a cell with a small red triangle in the corner will show you the source code of the Macro or Function To edit the code you may press [Alt-F11] and look for a module called Chapter. The Macro or Function should be in it....
View Full Document

Page1 / 10

Chapter 35 - Activecell Macros in this Workbook...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online