PDA

View Full Version : Copy and pasting time calculations



riteoh
01-09-2017, 03:33 AM
There is probably a very, VERY simple answer to this question, but I'm sorry - I can't solve it.

I have a spreadsheet with 2 countdown clocks. Cell A1 shows the countdown in Days, Minutes, Hours, Seconds. Cell A2 shows the countdown total in seconds only.

I have a button on the spreadsheet that updates these values. Simple so far. But the other function is to copy the CURRENT values for both cells, to cells (say C1, C3) BEFORE updating the values in Cells A1 and A2. A copy paste macro will copy one of the current values, but not both of the current values. If I copy paste indvidually, it results in one of the cells updating as the other is copy, pasted. Any ideas anybody?

The idea is to compare what the previous values were, before they are updated.

Thanks for the help.

offthelip
01-09-2017, 05:05 AM
You can do it by loading the values in to an array:

Arra= range(cells(1,1),cells(1,2))
Range(cells(1,3),cells(1,3))=Arra(1,1)
Range(cells(3,3),cells(3,3))=Arra(1,2)