Hi Paul,

I'm trying to do exactly the same as in the first example you did, I want them to be able to add rows only when they have completed the last field. my first column is just a sequential number.

I can't copy the macro, any chance you can repeat it in plain form so I can past that into VBA?