Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change - loop within a loop
Hi there
I am using WorkSheet_change to ascertain whether data has changed on the spreadsheet, and from there I check to see which cell it changed in. If it changed in a certain cell then I change all the values in that column using a For..Next loop. The only problem here is that it seems to trigger the Worksheet_Change macro everytime it changes one cell and starts at the beginning. Is there a way to surpress the Worksheet_Change trigger while performing a function thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change - loop within a loop
Yes, precede the code with
Application.EnableEvents = False make sure that you set it back to true before exiting the event macro. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "bgm" wrote in message ... Hi there, I am using WorkSheet_change to ascertain whether data has changed on the spreadsheet, and from there I check to see which cell it changed in. If it changed in a certain cell then I change all the values in that column using a For..Next loop. The only problem here is that it seems to trigger the Worksheet_Change macro everytime it changes one cell and starts at the beginning. Is there a way to surpress the Worksheet_Change trigger while performing a function? thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
For Each Loop | Excel Discussion (Misc queries) | |||
How would I add a loop for this? | Excel Discussion (Misc queries) | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Help with a Loop please | Excel Programming |