Limit Shift Cells to Left to a Certain Range

[FallingDown]

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

[cytop]

In the worksheet Class module, and very simplistically...

Please Login or Register  to view this content.

Changed to work with multiple cells, but not multiple areas. The selection must be contiguous...

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.