Hi I have some VBA code that I am modifying to add extracted information from an additional spreadsheet. I thought that I could just add another sheet into the declarations, but I am getting a subscript out of range error.
Can anyone help me figure out how to resolve it? Screenshot below shows that the worksheet I'm trying to refer to is Sheet 26 and my name is spelled correctly. Would really appreciate the help. I'm a complete novice!
Many thanks in anticipation!
Susan
VBA error - subscript out of range
-
luv2bounce
- StarLounger
- Posts: 73
- Joined: 07 Dec 2010, 12:21
VBA error - subscript out of range
You do not have the required permissions to view the files attached to this post.
-
HansV
- Administrator
- Posts: 80381
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: VBA error - subscript out of range
If you look closely at the left hand pane, you'll see that the name of the sheet is Northwwest with 2 w's. If you correct the name on the sheet tab, the code should work.
Best wishes,
Hans
Hans
-
luv2bounce
- StarLounger
- Posts: 73
- Joined: 07 Dec 2010, 12:21
Re: VBA error - subscript out of range
You know, I swear I looked at the spelling and just never saw it!!!!! Thank you for being so multi-talented! Skilled at excel and excellent at proofreading!!!!!-
luv2bounce
- StarLounger
- Posts: 73
- Joined: 07 Dec 2010, 12:21
Re: VBA error - subscript out of range
Works like a dream now!!!!!! thank you so much again!