Excel 2010 Bible

Chapter 43: Working with Excel Events 879 When the user attempts to save the workbook, the Workbook_BeforeSave procedure execute ...

Part VI: Programming Excel with VBA 880 TABLE 43.2 (continued) Event Action That Triggers the Event Calculate The worksheet is c ...

Chapter 43: Working with Excel Events 881 Monitoring a specific range for changes Although the Change event occurs when any cell ...

Part VI: Programming Excel with VBA 882 Using the SelectionChange event The following procedure demonstrates a SelectionChange e ...

Chapter 43: Working with Excel Events 883 Caution You won’t want to use this procedure if your worksheet contains background sha ...

Part VI: Programming Excel with VBA 884 In this example, the SetAlarm procedure uses the OnTime method of the Application object ...

Chapter 43: Working with Excel Events 885 Note The key codes are enclosed in brackets, not parentheses. For a complete list of t ...

...

887 CHAPTER VBA Examples IN THIS CHAPTER Working with ranges Working with charts Modifying properties VBA speed tips M y philoso ...

Part VI: Programming Excel with VBA 888 l (^) The macro recorder doesn’t always generate the most efficient code. Often, you can ...

Chapter 44: VBA Examples 889 The example demonstrates that the macro recorder doesn’t always generate the most efficient code. A ...

Part VI: Programming Excel with VBA 890 Selecting to the end of a row or column You probably are in the habit of using key combi ...

Chapter 44: VBA Examples 891 Sub MakeRowBold() ActiveCell.EntireRow.Font.Bold = True End Sub Moving a range Moving a range consi ...

Part VI: Programming Excel with VBA 892 Sub ProcessCells() Dim Cell As Range For Each Cell In Selection If Cell.Value < 0 The ...

Chapter 44: VBA Examples 893 On the CD This macro is available on the companion CD-ROM. The file is named skip blanks while loop ...

Part VI: Programming Excel with VBA 894 On the CD A workbook that contains this macro is available on the companion CD-ROM. The ...

Chapter 44: VBA Examples 895 Identifying a multiple selection Excel enables you to make a multiple selection by pressing Ctrl wh ...

Part VI: Programming Excel with VBA 896 If the active sheet contains a range named data, the following statement assigns the num ...

Chapter 44: VBA Examples 897 Sub CloseAllWorkbooks() Dim Book As Workbook For Each Book In Workbooks If Book.Name <> ThisW ...

Part VI: Programming Excel with VBA 898 Modifying the chart type The following example changes the chart type of every embedded ...