Microsoft Office Tutorials and References
In Depth Information
Creating and modifying macros
Edit the line of code that currently reads Range(“C4:C7”).Select so that it reads
Range(“C3:C9”).Select . This macro statement selects the cell range C3:C9 , not the
incorrect range C4:C7 .
On the Standard toolbar of the Visual Basic Editor, click the Save button to save your
On the title bar of the Visual Basic Editor window, click the Close button.
Select cells C3:C9 and format them as bold.
In the Macros list, click View Macros to open the Macro dialog box.
Click RemoveHighlight , and then click Run . The macro removes the bold formatting
from cells C3:C9 .
CLEAN UP Close the YearlySalesSummary workbook, saving your changes if you