LinkBack URL
About LinkBacks
dear, can someone help out please?
I am unable to save the file. I get following error 1004 document not saved
Please Login or Register to view this content.Please Login or Register to view this content.
dear, can someone help out please?
I am unable to save the file. I get following error 1004 document not saved
Please Login or Register to view this content.Please Login or Register to view this content.
In no way did I test the code, but I seeWould it not bePlease Login or Register to view this content.Please Login or Register to view this content.
still not working, getting same error 1004 document not saved...
Try this way.
Also you switch off DisplayAlerts 4 times. Where do you switch it back on again???Please Login or Register to view this content.
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.
when I set the display alert to true - i get following error message : there isn't enough memory to complete this action. Try using less data or closing other applications. T o increase memory availability consider: using a 64 bit version of microsoft excel or adding memory to your device
so that's the reason why the document cannot be saved , but how to solve this one?
Could it be I need to copy only rows with data rather and full sheets? I entered though Sheet1.Usedrange... How would I need to adapt the code to use less memory?
Last edited by rickmeister; 06-07-2017 at 09:55 AM.
solved - if I clear content of the sheet and copy the content I do not get the error msg.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks