Error 1004, abort all?
In this case I'm copy some range and paste it to another place.
This works fine. Only when there is no data in the copyrange I see a runtime error.
How to avoid the code and show users the errorcode what the problem is?
Please Login or Register to view this content.
Last edited by mreFF; 07-27-2014 at 09:41 AM.
Hi, mreff,
why not check if data is available by checking the last visible row number for the range to be greater than the row number for the header before trying to copy and only copy if there is data?
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thnx HahoBe,
Please Login or Register to view this content.
Last edited by mreFF; 07-27-2014 at 06:27 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks