Delete Merged Cells and move

Why oh why make use of merged cells...Rule No 1 in Excel...Do not merge cells...
Why not just increase the column width and row width for your exact size requirement...

Originally Posted by sintek

...Why not just increase the column width and row width for your exact size requirement...

AGREED! But I wrote this anyway (standard module):

Please Login or Register  to view this content.

...and this in the worksheet module:

Please Login or Register  to view this content.

Assign the Delete_Click macro to an AutoShape named Delete_Button, which will appear whenever you select a merged cell.
Click it to delete the active cell.

AGREED! But I wrote this anyway

Now just imagine how simplistic this would be if the "BUTTONS" were single cells...
Double click event... do the exercise and teach OP...

Originally Posted by sintek

Now just imagine how simplistic this would be if the "BUTTONS" were single cells...
Double click event... do the exercise and teach OP...

I think I'll leave the preachin' to you.
Meanwhile, I was never happy w/ the workflow in my previous code, so I wrote the following, which adds a "Remove Job #nnnn" command to the Cells Right-Click Context Menu. (right after Clear Contents). In a standard module:

Please see post#10; I fixed a bug in this code (and uploaded the workbook). - Lee

Please Login or Register  to view this content.

...and this in the Worksheet module:

Please Login or Register  to view this content.

Just right-click on the cell and select that command to process the removal.

get the proceeding jobs to move up to fill the blank by the deleted job

Non merged option...Simply...Double clicking on cell

Please Login or Register  to view this content.

Unless you mean something else by quote above...like having last used at last column to be moved to fill gap then...Not as simple...

Please Login or Register  to view this content.

Originally Posted by sintek

...Unless you mean something else ...

In the OPs original data, numbers are sorted top to bottom, then wrap around to the top of the next column. I'm just guessing, but I think the OP wants to preserve that order by moving everything below the Target up, and then moving the top of the next column into the open slot. Then the remainder of THAT column shifts up, and the top of the next column fills in...cascading down to the last column, which ends up having 1 less entry.

OPsNumbers.jpg

In the picture, he hasn't physically shifted the "New Numbers" columns, but logically, 2342 et al should move to the top, with ensuing columns filling in behind.

BTW, I'm glad you gave OP a demo w some actual code. Maybe he'll see the light... though I did have a problem on every 7th d-click. - Lee

Interesting thread this Lee...I like your out of the box thinking...I just assume that as each no box has a specific link, the order would not make a difference...Guess we'll only know once OP responds...

though I did have a problem on every 7th d-click

Guess I did not test to full capacity...Random selections etc etc ...

Hey, found a bug in my code - deleting a cell from first column caused the WHOLE bottom row to evaporate! I used a relative reference, when it should have been absolute. Here's the fix:

Please Login or Register  to view this content.

I also improved on the code for handling the custom control:

Please Login or Register  to view this content.