Garry,

Thanks for hanging in there.

Same error.

If Sheet2 has a name of "Settings", shouldn't Sheet2.ComboBox1 be the
same as Sheets("Settings").ComboBox1 ?

Also, the CLng, CInt and CDbl lines cause the following error to
display:

Compile error:

Expected: identifier


- Ronald K.