Rockee,

Most likely, you don't have a worksheet with same name as appears
in the list box. Are you sure that the list box names an
existing sheet?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Rockee052 " wrote in
message ...
Chip,

Thanks for your prompt reply, it works unless I click on my
option
command button then I get "script out of range" run time error
9. What
did I get myselft into?

Thanks

Rockee


---
Message posted from http://www.ExcelForum.com/