Ignore Blanks In Data Sort

[adam2308]

I have the following code to sort a table of 3 columns (B2:D157) into A-Z order by the middle column (Column C).

Please Login or Register  to view this content.

My problem is that many of the cells are empty and these empty cells are going to the top of the table when i run the macro. Instead, i want all the empty cells to stay below the cells with data.

Attached is a copy as an example.

[adam2308]

not too sure why but i don't think you can run the macro with the button but if you go into the macros you should at least be able to run it from there.

Thanks,
Adam.

[JBeaucaire]

1) You didn't connect the macro to the button, so no worries there, easy fix, yes?

2) Your column C "empty" cells aren't really empty, are they? Some sort of null characters in there? Do you know why that is? If you can simply clear those cells properly, the issue goes away.

3) I have added a routine to the beginning of this macro to sift through your column C values and remove these weird null values, then do your sort.

Please Login or Register  to view this content.

The macro is fine to use, but it's really best to analyze your work process and see if you can spot where the weird null values are being added into your sheets and try and solve it from there.