Hello,
I am working on a spreadsheet where I need a macro button that users can click on and add a copy of the last column to the end of the columns. I tried recording a macro, but it won't work because it inserts the columns in different places on the sheet and not at the end of the columns.
Thank you in advance for your assistance.
May be
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
A bit less code but quite similar to Yasser's code
AlfPlease Login or Register to view this content.
Hi Yasser,
Thank you. It's almost there. It is copying the column and placing it at the end, but it is not copying the format.
See attached image.
Picture2.png
Last edited by RubenExcel; 03-03-2017 at 09:07 AM.
Hello RubenExcel,
Please try the Code below.
Enjoy!Please Login or Register to view this content.
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] .
Hi,
I was trying to use this formula that I found in YouTube to copy rows - I modified it a little to copy columns, and it was almost working, but it was placing the columns in different parts of the sheet. It was copying the format of the other columns without content. Just wanted to share just in case it helps.
Please Login or Register to view this content.
Last edited by RubenExcel; 03-03-2017 at 11:51 AM.
That is because you are trying to bake a bread with the ingredients for soup. Why add extra code to obtain Borders, while my Code does everything as per your request, or does it not work for you?
Also Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
Please do that, since we all are bound to the Forum Rules.
Thank you so much.
Thanks. I had not tried your code when I posted that other formula. I posted it with the intention that it may help.
Sorry about the code thing. I think I fixed it.
I tried your code and it is working.
Thank you.
Yes, that's the way to Go! Thank you for adding the Code Tags.
You are Welcome RubenExcel, glad we could help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Good luck with your project further on!
Thanks.
@ Alf,
Using the UsedRange is not always that reliable, since Excel consider the last used Cell or Range, even if it has been Cleared, as part of the UsedRange while ignoring whether the Cell or Range contains Data or not.
@ YasserKhalil,
What a nice surprise!
Thank you for your acknowledgement, and for adding to my Reputation. I really appreciate it my friend!
Kind Regards.
Hi RubenExcel,
Thank for marking the Thread as Solved and for adding to my Reputation, much appreciated!
Kind Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks