Need help cleanup vb code.. Some errors!

[vexious]

Hey All,

So I made this bit of code. Pretty much the purpose is to timestamp as the phases of a project change. (Column G has a set of drop down boxes to choose from). However, I'm facing issues. Such as if you try to delete multiple rows it gives debug errors, and also inserting rows is blanked out. Not sure what all I can do to clean this code up to stop these errors.

Any help would be greatly appreciated!

Please Login or Register  to view this content.

[DGagnon]

Try adding a check to make sure only once cell is selected:

Please Login or Register  to view this content.

[vexious]

Ok that seemed to get rid of the debug errors, for some reason I can't right click and insert new rows inbetween rows for some reason.. any ideas? Also any suggestions to improve the code anymore?

Cheers!!

[DGagnon]

i would use a select/case instead of the IF's but im not sure why you are havin gissues inserting a new row

Please Login or Register  to view this content.