Hello Excelliot!
Okay, so here is what I did (and why it took me several days to work out).
I wanted to avoid your solution (using it as a last resort sort of code), because I wanted the process to be automatic (the user doesn't have to enter numbers, etc.)
After much gnashing of teeth I finally found the magical arrangement of code that does what I want, but (isn't it always something), a new problem arose that you might have some advice on.
First, here is the code that worked:
Where rownum is the row the button was pressed in, rowplus is the current row plus 1 (which is the start of the range I wanted to copy), and rSize is the result of the XlDown code you provided minus the rownum.
It ends up doing exactly what I described I wanted in my first post (clears the current row and copies all data below it to fill in the gap).
Here's the new problem: many cells unmerge. Oddly enough, if I keep running the code, when there gets to be only 1 to 2 entries remaining, the cells miraculously remerge (its just if there are 3 or more entries it "copied up", the middle entries will be in umerged cells).
I looked into this through Google and the main takeaway was that merged cells are the devil with macros haha. I'm not sure I care for the Center Across solution (although I may have to resort to it). Is there another solution you can think of that will keep the formatting, including the merged cells?
Bookmarks