I have a user defined VBA function that references named ranges in a worksheet. If a cell in the sheet calls the function, this function will be called when I sort the worksheet, but the ranges seem to be incompletely defined (because they are being sorted, I guess). Why isn't the update of the cell delayed until the sort is complete? Is there a workaround or redesign for this?