hi
i would use data validation instead. 300 combo boxes is a tad much. and data
validation is cell specific. and you should be able to copy and paste in mass
ie the whole column in one paste.
if you are unfamilar with data validation, see this site for details.
http://www.contextures.com/xlDataVal01.html

regards
FSt1
"CAM" wrote:

Hello,

I have a worksheet that contains about 300 rows in one column the user has
to input an account number. This is an expense report. My problem is that
the user always seems to never enter the account numberget correctly . I
seems that there always short by couple of digits. So I decide that I want
to put a combo box in all of the 300 rows, but the problem is how do I copy
and paste 299 rows of the combo box and have it properly reflect the cell
link to the proper cell in the row and stay in the cell without moving it?
Later I want to copy the rows to another worksheets, but the rows may vary.
Also do I have to be concern with the =Index() as well?. I am using Excel
2003. Any tips will be appreicated. Thank you in advance.