Subscript out of range

**bishoposiris** · 08-06-2009, 10:33 AM

edit: I found the issue for this. I had the worksheet (VCollinsville) misspelled in the Workbook.

I have the following code (it's long but my problem is at the end where I stop):

Please Login or Register  to view this content.

When I get to here:

Please Login or Register  to view this content.

I get the subscript out of range error. What's odd is it works just fine for the previous folder (Bothell) but when it gets here in the next folder (VCollinsville) I get this error. What could be causing this?

**Andy Pope** · 08-06-2009, 10:38 AM

If it works then the obvious question is does the worksheet VCollinsville actually exist?

A simple test would be to go to the Bothell worksheet and type,

CTRL+G
VCollinsville!A1

Do you get to the right place?

**Andy Pope** · 08-06-2009, 10:42 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

**bishoposiris** · 08-06-2009, 10:42 AM

Yes the code sees 3 spreadsheets in the folder VCollinsville. It opens the first one but when it tries to copy cell B2

Please Login or Register  to view this content.

I get the subscript out of range error. It pulled the spreadsheet from Bothell and executed perfectly which is why I'm confused. All the spreadsheet layouts are the same.