How can i delete an empty cell while looping in excel?

If i run a loop in excel and find a cell empty or null how can i delete it and move the remaining cells up, Delete Range isnt working here as the cell position is dynamic depending on the loop where it can occur!

1 Like

Hi @Prateek_Valvi

Did u mean to delete the rows whose any of cells is empty?

No Just the Cell

Can u share the sample excel file please ? @Prateek_Valvi

Text.xlsx (8.7 KB)

in your example read second column remove empty cells and re-write the column to excel, if you have more columns than one then iterate over columns. once you format it you can use as required.

Can u please elaborate?