excel 2007: run-time error '9': subscript out of range

**VBQuery** · 08-08-2010, 08:48 PM

Hi, am having issues importing worksheets from another workbook. Can anyone help, please?

Please Login or Register  to view this content.

**teylyn** · 08-08-2010, 09:01 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**ajaykgarg** · 08-09-2010, 02:12 AM

What issues are you having, VBQuery ?

**teylyn** · 08-09-2010, 02:19 AM

I acknowledge your effort, but next time, please use [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code], not quote tags.

**romperstomper** · 08-09-2010, 03:02 AM

You haven't said which line is causing the error, so all we can say is that a sheet name, workbook name or window caption is incorrect in your code.

**VBQuery** · 08-09-2010, 03:42 AM

Sorry, here is the line causing the error.

Sheets(Array("PlacementConfirmation", "Invoice", "Certificate", "WitnessChecklist" _
, "ClaimForm", "Affidavit", "Terms", "BrokerList")).Copy Before:=Workbooks( _
"Schedule Hole-in-One.xltm").Sheets(2)

**romperstomper** · 08-09-2010, 03:54 AM

Either one of those sheet names is wrong, or the Schedule template file name is wrong, or you don't have two sheets in your template file.
Where is the code located? (specifically, which code module in which workbook?)