Macro to move two cells up deleting the two above cell

[bumperjoe]

hello,
I need to move a cell (A2) and it's adjacent cell(B2) up and delete the two cells above it (A1) and (B1)



Thanks

 

[My Aswer Is This]

Re: how to use a macro to move two cells up deleting the two above cell

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

that is awesome. thanks again joe

 

[bumperjoe]

Re: how to use a macro to move two cells up deleting the two above cell

as I applied it tonight it shifts up all the cells below it, not just the 4 cells involved
so the column does not keep its integrity

 

[My Aswer Is This]

Re: how to use a macro to move two cells up deleting the two above cell

Any time you delete a cell all the cells below must shift up or left or right

You cannot just leave a empty hole.

Or do you just want to clear the values in the cells.

 

[bumperjoe]

Re: how to use a macro to move two cells up deleting the two above cell

just clear the values

 

[My Aswer Is This]

Re: how to use a macro to move two cells up deleting the two above cell

Now in your original post you said this:

I need to move a cell (A2) and it's adjacent cell(B2) up and delete the two cells above it (A1) and (B1)​

So My script will now clear the cell you double click on and the cell to the right of it.

Now if your doing this with columns

1 4 and 5 you will have a problem because:

When you double click on value in column 4 it will clear value in column 4 and 5

So try this:

Works on columns 4 5 and 6

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Modified 1-31-18 11:00 PM EST
If Target.Column = 1 Or Target.Column = 4 Or Target.Column = 5 Then
Cancel = True
Target.Resize(, 2).ClearContents
End If
End Sub

 

[bumperjoe]

Re: how to use a macro to move two cells up deleting the two above cell

I cannot get it to work
The columns are H and I
I would like 7.00 and 4.90 to move up and 1.00 and 3.00 to delete without shifting up the column


"H"...."I"
1.00... 3.00
7.00... 4.90
to
H.....I
7.00 4.90

 

[My Aswer Is This]

Re: how to use a macro to move two cells up deleting the two above cell

I getting confused:

Yesterday you said:

Post 8 you said: thank you. it work so great!
Post 10 you said: that is awesome. thanks again joe

But now tonight it seems as nothing now works the way you want.

 

[My Aswer Is This]

Re: how to use a macro to move two cells up deleting the two above cell

You just said:

I would like 7.00 and 4.90 to move up and 1.00 and 3.00 to ​

delete

​

without shifting up the column

​

You cannot delete a cell without it shifting up left or right
​

 

[bumperjoe]

Re: how to use a macro to move two cells up deleting the two above cell

I did not notice it was shifting up the column H and I . I looked at the end of the sheet and "H" and "I" were empty.
if you cannot delete without shifting like you would went you just hit the delete key then I guess it will not work

 

[My Aswer Is This]

Re: how to use a macro to move two cells up deleting the two above cell

When you press the delete key you are not deleting a cell. You are clearing the contents of a cell.