Hi,
I have multiple macros that starts when a value is added to a cell.
Once started the triggered macro then puts a value in the cell so different macros will continuously run till there is no more data.
My problem is two fold.
Macros only work if the value put in cell to trigger macro larger than previous value.
If a value is added into the cell is the same as prev value macro wont run.
I think I need a loop for the first issue and I have no clue how to fix second issue.
I am currently using worksheet change
I put in Application to stop endless loop as it just kept going and going. Only other issue I can think of is all macros are stored in same module but I cant see that as being it.
Any help would be appreciated.
Luke
I have multiple macros that starts when a value is added to a cell.
Once started the triggered macro then puts a value in the cell so different macros will continuously run till there is no more data.
My problem is two fold.
Macros only work if the value put in cell to trigger macro larger than previous value.
If a value is added into the cell is the same as prev value macro wont run.
I think I need a loop for the first issue and I have no clue how to fix second issue.
I am currently using worksheet change
I put in Application to stop endless loop as it just kept going and going. Only other issue I can think of is all macros are stored in same module but I cant see that as being it.
Any help would be appreciated.
Luke