I have one sheet were I import data from MS Access. I import two different sets of data, on set on rows 3-16 and another set on rows 17-25. When there isn't enough data to fill all of rows 3-16 I delete the unused rows and delete the header row, row 17. I am trying to use the macro below to find the total of column C (There is data in all the rows of column C), but it doesn't seem to recognize any of the data that is originally from rows 17-25. Any ideas would be appreciated.
Range("E65536").End(xlUp).Offset(2, -2).FormulaR1C1 = "=SUM(R2C3:R[-2]C)"<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
With Range("E65536").End(xlUp).Offset(2, -2).Borders(xlEdgeTop)<o></o>
.LineStyle = xlContinuous<o></o>
.Weight = xlThin<o></o>
End With<o></o>
With Range("E65536").End(xlUp).Offset(2, -2).Borders(xlEdgeBottom)<o></o>
.LineStyle = xlDouble<o></o>
.Weight = xlThick<o></o>
End With<o></o>
Range("E65536").End(xlUp).Offset(2, -2).FormulaR1C1 = "=SUM(R2C3:R[-2]C)"<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>With Range("E65536").End(xlUp).Offset(2, -2).Borders(xlEdgeTop)<o
></o>.LineStyle = xlContinuous<o
></o>.Weight = xlThin<o
></o>End With<o
></o>With Range("E65536").End(xlUp).Offset(2, -2).Borders(xlEdgeBottom)<o
></o>.LineStyle = xlDouble<o
></o>.Weight = xlThick<o
></o>End With<o
></o>
