Im trying to create a macro and Im having trouble with the last part. I
want to total a column (E) but the number of rows will vary day to day. For
example this totaled todays file with 726 rows but tomorrows file might
have 800 or 500 rows. How do I account for the various row size?

Range("E13").Select
Selection.End(xlDown).Select
Range("E726").Select
Selection.FormulaR1C1 = "=SUM(R[-724]C:R[-1]C)"