Hi I am getting this error in this code which is part of a larger macro. It always stops here giving the runtime error 1004 or 424 message. The macro sometimes gets through the whole sub routine and other times it gives this error. Thanks for your help.
End Sub
Please Login or Register to view this content.
Please Login or Register to view this content.
It stops where? It would be easier to test the code if you supplied a workbook sample
The workbook is confidential it must be deleted after. It stops at
Range(Selection, Selection.End(xlToRight)).Select
Perhaps this instead
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thank you for your response.
There is a compile error at .usedrange. Also did you include the paste values in the code?
That is what this line does
The syntax of that code is fine- can you copy and paste here the exact code you have now?Please Login or Register to view this content.
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and click "manage attachments" to open the upload window.
To add a file to a post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks