Hi All,

Developing a UserForm with CommandButtons, one for each week of the year. I
first inserted CB's (1-13) in a row representing the first Qtr of the year,
then copied and pasted this column across the Form. In the process of moving
the rows of buttons to their respective spot, I didn't keep them in order and
had to rename them to keep some order in the form.

Problem....when I got to the fourth column of CB's, the first one should be
labeled CommandButton40 but I got the "Could not set the Name property.
Ambiguous Name.".....then tried the number 41 with the same results until I
got to the number 53, which the form allowed. There are no other buttons on
this form, and in looking through the dropdown at the top of the properties
window, there are no CommandButtons 40 thru 52 listed, so I'm not sure why
I'm getting this error msg.

One thought just came to mind...I did paste one too many rows of buttons,
and deleted one of these rows. These may have been numbered 40-52. So, for
a test, I opened a new sheet and tried to duplicate the error......made a row
of CommandButtons (1-4), copied and pasted that row twice, ending up with two
more columns of buttons numbering (5-8 & 9-12). I deleted the middle row
(5-8) and then renamed (9-12) to (5-8).....the new names were accepted with
no problem. It would appear that the deleteing of the row in my original
form is not the problem.

Any help explaining this would be greatly appreciated.

TIA,

Don