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!
Did u mean to delete the rows whose any of cells is empty?
Can u share the sample excel file please ? @Prateek_Valvi
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?