onthegreen03
Board Regular
- Joined
- Jun 30, 2016
- Messages
- 148
- Office Version
- 365
- Platform
- Windows
Hi - I created a very simple sort macro (see below) that sorts a column of numbers. (I should mention I am not a code writer, I created this by recording a macro and moving through the steps.) Here's the hitch - Not all of the cells in column P will have a number all the time, some might contain a number and some might be blank depending on certain criteria selected. Is there a way to modify the code so that it sorts only the cells with a number and leaves blank cells at the bottom of the sort? Thank you!