Thanks Tom..
One more question....If I have 2 named ranges(let's say "data" an
"data1"), and depending on what the user inputs in TextBox1.Valu
determines on what *named range* the data gets inserted into. Fo
example, if TextBox1.Value = "Blue", information from TextBox1
TextBox2 and TextBox3 will be inserted into the named range "Data".
However, the data is being inserted onto the worksheet, but how do
code it to insert into a specified named range?
The range for Data1 is =Sheet1!$A$1:$E$10 and Data2 i
=Sheet1!$A$12:$E$19.

Thank you inadvance.
:confused

--
sulric
-----------------------------------------------------------------------
sulrich's Profile: http://www.excelforum.com/member.php...fo&userid=1997
View this thread: http://www.excelforum.com/showthread.php?threadid=34555