Clean up blanks in columns

[artz]

Hi,

I have an input area on a worksheet that is two columns wide, columns O and P. Data are entered or deleted in pairs. I want to clean up gaps when pairs are deleted without upsetting the formatting.

Deleting whole rows is not useable because it effects other parts of the worksheet and the formatting of the input area. I've tried more than a dozen macros that I found online and so far, every one messes up the worksheet.

It seems like the macro should copy, then paste the values one row up into the now blank row. I don't know how it would do this for multiple blank rows in the columns.

Does anyone in the Forum have an idea for a macro that could do this?

Thanks,

Art

 

[artz]

Hi Rick,

Somehow, my last post is out of order. Anyway, I shared your latest code which works perfectly with someone doing a similar operation. Though I didn't follow the explanation, he commented that your code, could over time, contribute to increasing file size if the user made many changes to the list, i.e., additions and deletions. This sounds absurd to me.

Do you have any idea about this?

Thanks,

Art