Excel Forum
I'm having a devil of a time getting this to work but here is the scenario:
I have a command button at the top of Sheet1; when I click on the command button I want it to copy A3:M6 on the same sheet and paste it starting at the next empty row, on the same sheet. If I record a simple copy and paste macro, it just pastes the new entry over the next one down.
All help appriciated.
Gideon
Hello j_gideon,
Try this code...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Works great, now how do I add the cell formating and borders? Thanks.
Hello j_gideon,
Just need to change the last line of the code.
Please Login or Register to view this content.
That did it, I updated your reputation, perfect solution. Thanks.
Hello Hello j_gideon,,
Thanks and you're welcome. The first example is very fast for copying large data sets especially when you have the columns cell formats already set. You may find this useful in the future.
@ Leith Ross,
Glad the OP got it.
Kind Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks