Copy one cell to another every hour

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Copy one cell to another every hour

FAQ

Thread Tools

Display Modes

02-21-2019, 05:41 AM

NoSparks

Windows 7 64bit Copy one cell to another every hour

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Quote:

But the last code I do not know where it should be.

Worksheet_Change is a worksheet event and must be in the sheet module not a standard module.
It will re-write I2:I30 every time A1 changes, not hourly.
And that is actually dependent on how A1 receives its value.
If there's a formula in A1, the Worksheet_Change event will never trigger, because what's in the cell (ie: the formula) never changes even though the displayed result does.

Last edited by NoSparks; 02-21-2019 at 01:28 PM.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy matching data from one report cell to another cell report	mbesspiata	Excel	9	01-15-2015 01:49 PM
Copy Rows down with value from another Cell	burlinghamla	Excel	1	01-14-2015 06:26 AM
keyboard shortcut to copy the url of a cell	Aquinax	Excel	3	07-15-2014 09:45 AM
Copy Paste each cell to a new page	Singh_Edm	Word	12	01-20-2014 12:55 AM
Can Excel Deduct 30 Minutes from an 8 1/2 Hour Cell?	tatihulot	Excel	4	05-16-2013 04:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:54 AM.