Try this when you're recording the macro:

Select your range with the empty cells.
Edit|goto|special
check Blanks
right click on one of the selected cells
Delete|and shift up

Did it do what you wanted?



Gary wrote:

I would like to write a code to check a range of cells and
delete that range in that row if they are empty and shift
up the next row in the range. Then go to the next row and
start all over again. I have found examples of deleting
entire rows, however I do not want to do that, just a
range of cells in a row. Can anyone point me in the right
direction? Perhaps some key methods or examples? Thanks
for any input.

--

Dave Peterson