Calculate sum using VBA

Hi all, I have a macro which takes live data every second from Range P5 to P60 and pastes it into cells AA105 to AA160 - it then shifts the data already in AA105 to AA160 into AB104 to AB160 thus shifting everything to the right as per the code below

Please Login or Register  to view this content.

What I want to do in rows 205: 260 is calculate the difference between AB105:AB160 and AA105:AB160 as that moves along.

Something like

Range("AA205:AA260").Value = Range("AB105:AB160").Value - Range("AA105:AA160").Value

Only the code above is not correct and I would like to know the correct way to do this. I hope I have explained it well enough

This version takes my formula solution and adds turning the formulas into values. This is probably faster than doing all the arithmetic in VBA code:

Please Login or Register  to view this content.

Thanks all, I will give them a try today and let you know how I get on