Hi
I need some help trying to delete blank cells in a range and shifting them up.
In the example below, I want to check each cell in the range from D4 to last row and if ALL of the cells are blank in each range, e.g. A4 to J4, then delete the cells from A4 to J4 and shift up. Then repeat for all the cells in the range.
I have written the following but nothing is happening? Can anyone please assist?
Please Login or Register to view this content.
Bookmarks