Find empty cell in column and delete that row

Hi all,

I would like to take advice.

I would like to search in column "B" all cells, if will be empty cell, then, delete full row, where is this cell

or

Maybe more complicated.

Search column "B" and if there will be empty cell, write to this cell same value which is exactly above this cell.


2nd way will be helpfull for me.

thanks

Hi, xbr088,

maybe

Please Login or Register  to view this content.

Ciao,
Holger

Hi, xbr088,

what about

Please Login or Register  to view this content.

Ciao,
Holger

Hi, xbr088,

to be honest: the worst of all error handlers possible. Any error that occurs will not get noted, the code goes on as if nothing has happend. This may lead to very strange results and very different outcomes from the expected if values arenīt filled the proper way.

Within the small macro here it just tells VBA to go on if no empty cells are to be found in the given range (otherwise an error would break the code execution and show up a message).

Ciao,
Holger

Wrote messages in similar time. And what about some next rows in macro? are they influenced by this also? it means dont need to know some others debug popups ? (maybe from below functions?)

Hi, xbr088,

And what about some next rows in macro? will it have influence to all what is below ?

Definitely as no error handling takes place.

You may set back the error handling to VBA by using

Please Login or Register  to view this content.

If you want to implement the small code into a larger one you may use something like

Please Login or Register  to view this content.

Ciao,
Holger

Hi, xbr088,

are you developing excel

If somebody comes and asks for an application I may do so (but certainly could not make a living of that). Mostly Iīm trying to help people in Forums (most recently mostly this one).

you know everything about VBA

Not as much as I wish to know - especially not with the newer versions from 2007 on.

Ciao,
Holger