Читать книгу Excel Macros For Dummies онлайн

7 страница из 60

7 Chapter 7FIGURE 7-1: Imported numbers are sometimes formatted as text.FIGURE 7-2: Click the Text to Columns command.FIGURE 7-3: Clicking Finish in the Text to Columns dialog box corrects incorrec...FIGURE 7-4: This macro dynamically finds and highlights the duplicate values in...FIGURE 7-5: This macro ensures that only those rows that contain duplicate valu...FIGURE 7-6: The standard AutoFilter functionality adds drop-down arrows to all ...FIGURE 7-7: With a little VBA, you can choose to hide certain AutoFilter drop-d...FIGURE 7-8: This macro lists all filtered columns in the status bar.FIGURE 7-9: Type or paste your code in the Worksheet_Calculate event Code pane.

8 Chapter 8FIGURE 8-1: A PivotTable inventory summary.FIGURE 8-2: Excel shows the enumeration choices.FIGURE 8-3: Type or paste your code in the Worksheet_BeforeDoubleClick event Co...FIGURE 8-4: Enter or paste your code in the Workbook_BeforeClose event Code pan...FIGURE 8-5: The Selection pane allows you to see all of your chart objects' nam...