Mhelp4Ucom‎ > ‎Office 2007 ▼‎ > ‎Excel 2007 ▼‎ > ‎

How to count sheets in a range using macros in Excel

                                                                Contact us for Site Advertising Rates & Metrics    

                                                                           

                                                                                                                                                Report Errors & Bugs

 


                                          How to count sheets in a range using macros in Excel

                                                                         This Mhelp clip will show you how to count sheets in a range using macros in Excel.

                                                                                   This Mhelp clip has twelve steps.
                                                                                    1 - Click the View tab.
                                                                                    2 - Under Macros, click Macros. A menu will appear.
                                                                                    3 - Click View Macros. A dialog box will appear.
                                                                                    4 - Under Macro name, type a name for the macro.
                                                                                    5 - Click Create. A window will appear.
                                                                                    6 - Type the code for your macro. 
                                                                                    7 - Close the window when finished.
                                                                                    8 - Click the View tab.
                                                                                    9 - Under Macros, click Macros. A menu will appear.
                                                                                   10 - Click View Macros. A dialog box will appear.
                                                                                   11 - Click the macro that was created.
                                                                                   12 - Click Run.

                                                                            Note: This will count the selected sheets in the selected range.

                                                                           This concludes the Mhelp clip.