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.

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

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