>Is there a way of accessing a "Rows Collection" in excel that will allow me to step through all of the rows checking the value of a column for a change or a total line or somthing of the sort?

Bill,

This example is from Excel's VBA help file:

For Each rw In Worksheets(1).Cells(1, 1).CurrentRegion.Rows
  this = rw.Cells(1, 1).Value
  If this = last Then rw.Delete
  last = this
Next

Look for the rows property which contains a collection of all the rows in a worksheet.