Thread: Module 1 - Subscript out of range error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craigm[_18_] Craigm[_18_] is offline
external usenet poster
  
Posts: 1
Default Module 1 - Subscript out of range error

Set wbBook = Workbooks("C:\Temp\Charts_ChgAll2.xls")
-------------------------
I moved all my macro code from "Thisworkbook" to "Module1" in the sam
workbook. The code was running before I moved it.

Now I am getting a "Subscript out of range error" on the above line?

--------------------------------------------------------------
I am strangely confused and in the deep end too.

Craig

--
Craig
-----------------------------------------------------------------------
Craigm's Profile: http://www.excelforum.com/member.php...fo&userid=2438
View this thread: http://www.excelforum.com/showthread.php?threadid=38276

Reply With QuoteReply With Quote