I have this code it works on my computer just fine, but when I have another person run it, it fails with the above runtime error. The other person's system has Excel 2007 and only had 2007 on it. My computer has had both 97 and 2007 on if it makes any difference.
The code fails at the highlighted yellow spot. If I change the range to "Q2:Q250000" it fails on my computer the same way.
Please Login or Register to view this content.
It could be due to version difference
version 97 has only some 65536 rows
2007 much much more. your last row is 201597
A better option than hard-coding the last used row is use a variable:
Hope this helps.Please Login or Register to view this content.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks