One approach might be to use a helper column with different formulas:

=if(a1="","zzzzzz",a1)
(dragged down)

Then sort by that column. (choose a nice string so that it sorts last.)

You could even have your macro add a column, add the formula, do the sort, and
remove the column.



Pat wrote:

Example:

A1:A10 each contains a formula
A1:A8 contains the result of the formula
A9:A10 contains only the formula but no value

If a sort is carried out on A1:A10 this will result in A1:A2 displaying
empty cells
and A3:A10 displaying the sorted recorded. The reason for this is that any
cell containing no value but only the formula the formula will be displayed
first at the top of the sorted list.

Anyone know if there is code which could be included into a custom sort
command button which takes this into account and prevents the formula form
displaying at the top of the sorted range displaying empty cells.

Thanks for any help with this.

Pat

--

Dave Peterson