Delete Empty Cells With VBA

Hello friend,

I am a little confused as to whether the cells contain the quotation marks or if they are blank and you used quotation marks to illustrate they are blank. In response to if the cell has a value of zero here is a loop which will work for you.

Please Login or Register  to view this content.

Note: You will want to adjust the range to meet your needs. Also, since i wasn't sure what the range was this may not be the best way to do what you want to do. For example if the range is really big this macro will be really slow. Let me know.

Hi there

Thanks for the code, i realised what i needed to do & adapted it to suit. I have included the code below to help anyone who might see it & need similar.

Cheers
Mark

Please Login or Register  to view this content.

Just wanted to update a better way for future readers now that I see what you want to do

Try:

Please Login or Register  to view this content.

This way we only focus on column A rather than all the cells. Much faster