I am using the code below to move rows from one worksheet to another when "Done" is selected from a drop down menu.?* It worked fine on my computer and when I first shared with another user however now it freezes excel and you have to restart the program.?* She (other user) is on a network shared folder; i am not.?* Can anyone help??* I have included code below.
Please Login or Register to view this content.
Last edited by AliGW; 03-18-2024 at 03:44 AM. Reason: Code tags added - please review the forum guidelines.
Step through the code using F8. Check the value of xRg.Count. I suspect the Used Range may be very high for some reason. I think that Excel is not actually freezing, just taking a long time to work through a lot of rows.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
If you want to stick to a 2 sub solution change both subs to this.
andPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by bakerman2; 03-19-2024 at 11:40 PM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks