Sorting Data Range With Formulas

  • Hi all,

    I need some help on a sorting macro.

    I have a range C11:O104 I would like to sort Ascending first from Column E then Column D

    Only problem is that all cells have formulas so when this macros is run, I get blank cells sorting as well and they end up at the top.

    I have tried to remove blank cells, but I do not want to delete the rows OR the formulas from the cells.

    Can anyone help sort my range with blank cells that contain formulas?


    Tayler [the blue fox] :thanx:

  • Re: Sorting Data Range With Formulas

    If you don't want the blank rows to be sorted to the top, what do you want Excel to do with them if they can't be deleted either? Are they simply blank cells waiting for data to be entered later?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!