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

How to count rows, columns and sheets in a range using macros in Excel

                                               Contact us for Site Advertising Rates & Metrics    

                                                                           

                                                                                                                                              Report Errors & Bugs

 
 

 

                                   How to count rows, columns and sheets in a range using macros in Excel

                                                                         This Mhelp clip will show you how to count rows, columns and 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 rows, columns or sheets in the selected range.

                                                                               This concludes the Mhelp clip.