Delete a range of row cells but not the entire row and shift cells up? VBA

[tarunr9]

I want a VBA code which looks at column G and find blank cells , and then delete the row cells from column A to O and shift cells up. For result to look like the second pic. If I delete entire row, the button gets deleted, which I dont want.
Thank you in advance

 

[My Aswer Is This]

The button looks like a shape.
To stop from deleting the shape do this:
1.Right click on Shape
2. Choose Properties
3. Choose Don't move or size with cells.
Now the shape will not move or be deleted
No Vba required

 

[tarunr9]

The button looks like a shape.
To stop from deleting the shape do this:
1.Right click on Shape
2. Choose Properties
3. Choose Don't move or size with cells.
Now the shape will not move or be deleted
No Vba required

perfect. Thank you

 

[My Aswer Is This]

perfect. Thank you

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