Hi all

My file has one record per line.
In Range BI:BS it may happen that the user deletes a certain value.
The macro that will run should rearrange the values, so that there are no blank cells between values.
However, values after column BS should remain where they are.

234 123 345 456

should be re-arranged to

234 123 345 456

Important, the order of the values itself should not be changed.
i.e. it should NOT look like this

123 245 345 456

How do I do that?

Thanks FD