Adding new rows using VBA everytime there is an "Error"

Not sure I really understand your issue, but you can try this. The code should be copied and pasted to the worksheet code module of the sheet where you want the rows inserted. This code will run when a user makes a change to the worksheet. If the change is in columns P, Q or R it will evaluate the entry to determine if an error resulted. If it is an error, it will insert a row immediately beneath the row the entry was made on. To access the code module, right click the sheet name tab, then click 'View Code' in the pop up menu. After posting the code, save the file and close the editor. The code will then run when any change is made to the sheet but will only execute the insert if there is an error in one of the three columns. It will not execute if more than one cell is changed at a time.

Please Login or Register  to view this content.