CBrausa,

Once the mandatory cells have been filled, then the user can move to any other cell and enter any
information that they want.

In all of my tests, the code has worked. Send me a copy of your workbook, with the mandatory cells
highlighted with color, and I will figure out what's going on in your workbook. Reply to me, then
take out the spaces and change the dot to .

HTH,
Bernie
MS Excel MVP


"CBrausa" wrote in message
...

they have always been merged. It's not moving to the next mandatory
cell.
can the other cells then be filled in with what ever ifo the buyer
wants listed?


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=520114