Luxury Orlando Vacation Accomodations

Appalachian Mountains Banner

Microsoft Office XP Secrets and Tips by Zac

Zac is one-half of the team that brings the Village to you.
He has become the county's Microsoft Office XP resident guru, and will be sharing some of his hard-earned knowledge with us all.

His column is updated every weekday, or thereabouts, so check back often for new secrets and tips.

A Row Counting Excel Macro

Here's a simple macro that you can use to count the number of rows in a selected range.

To enter the macro,

  • Choose Tools|Macro|Macros.

  • Click in the "Macro name" entry box and type in RowCount.

  • Click Create and enter the macro as shown below.

  • Note that Excel will automatically enter Sub RowCount() and End Sub so you really only need to enter the middle two rows.
    Sub RowCount()
    X = Selection.Rows.Count
    MsgBox X
    End Sub

  • Press Alt + Q to return to Excel.
  • Select cells A1 through A5 and then press Alt + F8.

    Double-click RowCount to run it.

    It should report the number of selected rows.

    Note: This is a very simple macro, but one you can add other features to as you learn more about writing macros.

    Do you have some Microsoft Office XP tips or secrets to share or have a question?

    You can Write to Zac!.

    Include your first initial and last name and put the word OFFICE XP in the subject.

    I'll try to use your contribution in a future column.

    (Please note that these columns are written several weeks in advance so publishing it will be delayed accordingly.)

    A NEW Microsoft Office with all its tweaks.

    Ain't if FUN!!!!!!


    Return  to Appalachian Spring Mall Home Page