VBA to Delete Range Shift to xlToUp

It should be

Please Login or Register  to view this content.

hi, fluff i made a big mistake it should the post delete empty specific range what you suggest issue a new post ?

What is the specific range?

this range Range("B2:D10") it contains some data and some empty data so it supposes delete any empty cell in this range without effect in column f

Does the whole row have to be blank?

no just this is range because i fill some data after this range

Please Login or Register  to view this content.

Give it a try

Please Login or Register  to view this content.

hi, jolivanes it something wrong you can see my image
Attachment 679194

hi, Vraag en actually your code doesn't work

No, we cannot.
You have to go to the bottom and click on "Go Advanced" to attach a file.

What doesn't work on the code? Just shouting that it doesn't work gives little information.

here is the image

That is very special if this is in the example file.

Vraag en your code doesn't work at all it supposes delete row 3, 5

Like VenA mentioned, what are we to do with that picture. Probably tells you a story but not us.
Attach a workbook with a before and after.

Please Login or Register  to view this content.

it supposes delete rows3,5 but your code doesn't work at all

thanks jolivanes awesome code

Glad you've got it solved.
Eid Moubarak