View Single Post
 
Old 08-16-2011, 05:39 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

ok, look at this line, which does all the job:
Cells(1, 1).Value = Cells(lastrow, 1).Value - Cells(2, 1).Value
maybe you can use this instead :
Cells(1, 1).Value = Cells(lastrow, 1).Value - Cells(lastrow-1, 1).Value
it subtracts the last value from the previous...
Reply With Quote