Excel Macros for grade sheets

• EveryN

  Puts emphasis on every Nth row's border. The major improvement was making the macro use the current selection as its range to work on. Extra emphasis is placed on the top and bottom edges of the selected area.

• everyNcol

  Same as everyN excep that it works on columns instead of rows.

• sortRows

  The old grade sorting macro made to work with a user selected area in the spreadsheet.

The newer macros have been bundled together in one file wich has had a toolbar attached to it. The toolbar contains three Macro invoking buttons.

Excel Techniques

Row/Column - see if current selection is an entire row or column

    Set a = Selection       ' save current selection
    If a.Address = a.EntireColumn.Address Then
        MsgBox "Please select entire rows" & vbLf & _
            "or a finite range of cells" & vbLf & _
            "rather than entire columns.", vbCritical
                                    ' vbInformation is another type of message
        Exit Sub
    End If

Histogram - using the frequency function to count a grade of 90 as being in the 90 to 100 bin instead of the 80 to 90 bin.

Negate the data range in the FREQUENCIES function. Also, negate your bin divisions (and reverse their order).




Chart - add flags (graphic with text and number) along the horizontal axis

14-Feb-2002, coming eventually.