Hello

I have a series of ranges, eg a1:a10
This range contains words in some cells and numbers in
others.
I successfully replace all certain words with "" and sort
the range using A1 as the key.
However, after it's been sorted there are a number of
blank cells at the top.
Since I will be using this range to load a combobox I'd
like to shift the whole lot up and remove the blank spaces
at the top.

Any ideas?