Hi all,

I have quiet a few dropdown boxes on my w/s (combo boxes, 56 in all!),
i have assigned named ranges for the data in each box but i have not
done anything with linked cell (as i dont know what this does) what i
would like to do is click my command button and have all dropdown box
data copied down from the next availabe cell where i will use the
ActiveCell.Offset(x,x) to place the data where i want after
that........so i need help with the dropdown copy contents and paste to
lets say sheet3, but after contents have been pasted i would like all
the NEW data to be a named range using the text in the TextBox2 on the
w/s...........is this possible?

Hope you can help!

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=543729