My macro has been working fine for months but just crashed today. I don't find anything noticeable about the files that has changed. it crashes at the line that counts the number of rows. Any idea what's wrong? I have tried different ways of writing it as well but it crashes at "Lstrow ="...Below is the original code:
HTML Code:
It works for me, I had to change a few things to make it run on my pc.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
I don't know why it used to work and now does not, but I see a likely problem. In the line of code getting the error, put a "." before "Rows.Count". Without the dot, VBA assumes that Rows.Count refers to the active sheet. So this works only if wb1.Sheets(1) is the active sheet, and there is nothing in the code to guarantee that is the case.
I am still not sure why that would raise an error but the best practice is to fix everything you know is wrong then see what problems are left.
yes the . before the rows fixed the issue. i'm not sure why it was fine before. thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks