VBA CODE Question

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

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
 
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?
 
Back
Top