Delete and select empty Cells

[tharindudk]

Hi I am trying to delete/select empty cells in Column C.

I tested the code in my work sheet which has close to a million rows. this code for some reason doesnt work. its selecting empty cells from Cell C, that is not working.

when I test it on a new worksheet it worked fine. Any idea how to improve the code?

Please Login or Register  to view this content.

Thankyou

[jewelsharma]

quick suggestion: remove the ".Cells(1)" part in your code & try again. (that is probably making excel select the first cell of all the cells that are blank)

Please Login or Register  to view this content.