Why aren't you using the loop variable wshLoop in the second For loop?
In that loop you only refer to bk.Worksheets(1) which is the first worksheet in the workbook you just opened.
Actually, why do you have 2 loops?
As far as I can see they are identical.
Last edited by Norie; 05-10-2014 at 07:49 AM.
If posting code please use code tags, see here.
O.o wow how could I miss that?
Thank you I had a brain fart lol.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks