I need to detect when all cells in A1 to Z1 have changed and then execute some code. I've tried using intersect target method but I don't think it will work when i need to know that all the cells have changed.
I need to detect when all cells in A1 to Z1 have changed and then execute some code. I've tried using intersect target method but I don't think it will work when i need to know that all the cells have changed.
Cells A1 to Z1 change all at a time or cell by cell ?
They change cell by cell. It takes about 1 second for all of the cells to update.
So it's more difficult … Original cells values must be saved before elsewhere …
I set row B equal to row A. When row A updates I use:
This is working for what I have. Thanks!If Sheets("Template").Range("A1") <> Sheets("Template").Range("A2") _ And Sheets("Template").Range("Z1") <> Sheets("Template").Range("Z2") Then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks