Thread: Type Mismatch
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rockee052[_62_] Rockee052[_62_] is offline
external usenet poster
 
Posts: 1
Default Type Mismatch

Chip,

All the sheets are in the listbox are existing sheets. It does wor
correctly until I hit the options command button, thats when things ge
a little crazy. Once the option command button has been clicked, I ge
the run time error "Script out of range" in the line of code
Worksheets(ListBox1.Text).Activate. But, it does work correctly until
click on the options button...

Again thanks for help

Rocke

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