I have to clear a worksheet except for certain things, so a new bill can be
entered. The trouble is it only deletes the actual combo box that was there
when the macro was recorded any way of getting round it?

Thanks