vodkasoda
06-25-2011, 02:39 AM
I've written a small application for my nephew that checks if a Cell in a certain Range is amended, then the sheet is updated by taking all of the data in that Range & replicating it below, but sorted into Column D order.
The attached is a very small example of this and I am happy with how it works ... HOWEVER ... if I delete a line, although the program seems to step through perfectly OK, Excel then goes into some kind of loop, it certainly isn't responding, I have to use Task Manager to end the Excel process !!!
I can obviously look into the "Insert" option myself when I understand why this is happening, as "Insert" will need a small routine of its own anyway ...
Can anybody help & explain what is going on and why :help ?!?!?
The attached is a very small example of this and I am happy with how it works ... HOWEVER ... if I delete a line, although the program seems to step through perfectly OK, Excel then goes into some kind of loop, it certainly isn't responding, I have to use Task Manager to end the Excel process !!!
I can obviously look into the "Insert" option myself when I understand why this is happening, as "Insert" will need a small routine of its own anyway ...
Can anybody help & explain what is going on and why :help ?!?!?