View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
 
Posts: 599
Default "Subscript of range" error

Bhodge

I'd guess it's here


Windows("Macro based quote template-1.xls").Activate


If you want to activate the workbook that contains the code, you can use

ThisWorkbook.Activate

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.