I am using the macro below to merge all selected cells vertically to the top selected cell(s). I am looking to delete the entire rows of the cells below the top selected cell after they have been merged. Any ideas on how to accomplish this? Thanks.
Please Login or Register to view this content.
Last edited by Brawnystaff; 10-25-2014 at 08:37 PM.
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Any way to limit the rows deleted to only those with selected cells (minus the top row which will contain the merged data)? Thanks.
Actually, after looking at your code, I believe I have solved it using the following code:
This will be marked as solved. ThanksPlease Login or Register to view this content.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks