Code not giving the ouptut but syntactically correct

Originally Posted by millz

It should be:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Edit: You may want to exit the loop once you find a non-blank cell, so you don't continue all the way till the end

Please Login or Register  to view this content.

Hi Millz,

Modifying with the above code, the ouput is like-

Wherever empty cells are there, the values is replaced with the successor.

I don't want the value to be repeated, instead I want all values to be consecutively
present without any blanks between them.

e.g.
if Input is-

8
9


6
4




2
1

then outout shoukd be-
8
9
6
4
2
1

Hi Veena Anoohya

... and makes values in sequence for a column.

Do you mean you want empty cells removed AND sort the remaining populated cells ?

Hi Millz,

Thanks for the code


Hi GreyGhost,

Query solved, actually I wanted to delete blank cells.