Try this. Delete your named range, merge the cells that you want to have
merged, then select your cells for the named range and rename it. If you
merge the cells AFTER the name was created, then the second cell of each
merged cell will cause a problem.

Bernie


"CBrausa" wrote in
message ...

Bernie-
Thank you so much for your help. It works up to a certain point and
then it stops. Does it make a difference if two cells are merged?
Once all of the mandatory cells are filled in, can they fill in info in
the other cells in that row that pertain to them that are not
mandatory?
B10 is merged with B11. This is the cell that if something is in the
cell then the mandatory cells have to be filled in.
It jumps to the header cells that have to be filled in it then jumps
over to the first mandatory cell in the row, I enter a number and it
won't continue to the next cell. The other cells that are mandatory are
in F10/11 merged as are cells H10/11, S10/11. These have to be filled
in but the other cells in the row need info only if the buyer deems it
necessary. Where do I go from here?


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