do while loop

[bopsgtir]

I know i've got the below syntax wrong for the loop but can someone point me in the right direction, i know what i want to say but cant seem to put it right

Please Login or Register  to view this content.

[HaHoBe]

Hi, bopsgtir,

by using a Do Loop you may miss a row to be deleted:

Please Login or Register  to view this content.

I prefer to start at the bottom and work up to the top like this:

Please Login or Register  to view this content.

Ciao,
Holger

[bopsgtir]

l

Please Login or Register  to view this content.

would that just count to the first blank cell? as there can be blank cells there just cant be 3 in a row.

[HaHoBe]

Hi, bopsgtir,

the command would find the last visible filled cell in column "B" (filled with either a value or a formula), starting at the very end of the spreadsheet and working up (according to CTRL+Up command). There could be added a check to see if the last cell in that column is filled.

Ciao,
Holger

[bopsgtir]

Sorry yes i see now, i was thinking xldown, but like you said work for the bottom up, makes sense now thank you for your help.