Runtime Error 9 - Subscript out of range
Hello friends,
i am trying to consolidate data in Sheet7 of all the files in a folder to a single file. In case a file doesn't contain Sheet7, i want to get the name of the workbook. The code is working fine, but after it loops it is returning Runtime Error 9 - Subscript out of range. Please help. Thanks in advance.
Here is my code
Please Login or Register to view this content.
Last edited by Swalih; 02-12-2014 at 01:27 AM.
i m sorry. i am new to the forum. I have done the updations.
Try clearing the error see if it helps
Please Login or Register to view this content.
多么想要告诉你 我好喜欢你
Thank u for the support millz, but still it is not working. when i am testing the code using F8 it returns "Run-time error '-2147352565 (8002000b)' The Specified dimension is not valid for the current chart type." I am not using any charts & if i click Debug, and press F8 again the in returns the Run time error 9
Replace this
WithPlease Login or Register to view this content.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Wow that was superb. Thank u very much for ur helpSixthsense
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks