In a userform I have this code deletes a driver record. I am trying to keep a copy of the record before deleting in worksheet "Removed Drivers"
I have tried this but although the message box displays the correct row number the macro does not paste the record. I can select the cell but it appears nothing is held in the clipboard. Any pointers appreciated
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by nigelog; 05-15-2017 at 06:42 AM.
Hi nigelog
This is one way:
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Does your 2nd code block even compile? There seems to be a surplus 'End If' ...
Also, it would help if you uploaded a sample copy of your workbook, just with the relevant sheets, code and userform - save anybody having to go to the bother of recreating something that already exists.
@sintek .. appreciated, did the job. Ta
@cytop .. Code was cut and paste I probably made a mistake removing other code and I was interrupted as I stripped the workbook back and had no chance to attach. I will ensure workbook attached in future posts
Pleasure...thanks for rep point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks