Select the relevant range of cells before you sort.
--
David Biddulph

"Dyefrog" wrote in message
...
In the same workbook, i have a cell that references another worksheet cell
which gets re-sorted on occasion. When the source is re-sorted, the
destination cell does not follow that cell. Changing the wildcards doesn't
seem to have any effect. What am i missing?