(solved)Subscript out of range

**Genzo** · 08-17-2011, 05:23 AM

Hi

I get an error when i try to run this script/macro

Please Login or Register  to view this content.

when i debug it marks the line that starts with For each
i checked to make sure the filename was spelled correct

Anything ive forgotten?

Solved: Error is caused by file not found

**Bob Phillips** · 08-17-2011, 05:39 AM

Sounds as if there is no workbook with that name or no such worksheet. Check the worksheet name doesn't have a space at the end.

**Genzo** · 08-17-2011, 05:43 AM

no spaces in worksheet name

**snb** · 08-17-2011, 05:46 AM

Please, add code tags to your code (see the forum rules)

Please Login or Register  to view this content.

**Genzo** · 08-17-2011, 05:59 AM

it seems to work when i have the worksheets open

Im gonna cry if thats the problem

**Bob Phillips** · 08-17-2011, 06:01 AM

Originally Posted by Genzo

it seems to work when i have the worksheets open

Im gonna cry if thats the problem

Worksheets or workbook?

Re: Subscript out of range