I won;t tell you how to do this - but I will point you in
the right direction.

Goto tools - Macros -- record new macro.

perform the actions you want to automate and then review
the code created by going to the VBA editor. it won't be
elegant but it should put you on the path.

Its better to discover than to be shown.

Craig Mitchell

-----Original Message-----
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.
.