I have modified the code to suit my needs and it works just how I want it to.
Thanks for the help....
Macolm64
Last Activity: Sep 28 '06, 08:13 PM
Joined: Sep 27 '06
Location:
-
Ok thanks.
Now for the loop problem. The code I have does not loop. I want the procedure to loop until cell L1 = M1...Leave a comment:
-
Thanks for the quick response.
Where am I meant to put this new code? I tried it in "This Workbook" object and the specific sheet object for where I want the code to look for a change.
Note: Im working with sheet 2 so I changed the two references in your code to sheet2.
What do the cell numbers refer to in your code eg Cells(1, 12)...Leave a comment:
-
Excel loop, run when cells value changes
I am looking for some code that would loop until two cell values in excel equal the same. By cell value I mean the result of the formulas in the cells are the same.
This procedure needs to be run when a cells value changes, again I mean result of the formula in that cell changes.
For the loop part I have written the following code which works as if the loop didn't exist.
Do
Range("A1").Sel ect...
No activity results to display
Leave a comment: