Hi, Keith. The general principle is that worksheet functions can affect only the value displayed in that cell, not in any other cell. Offhand it seems to me that must apply to moving the selection to another cell, too.

You can do it, but not with worksheet functions; you'd have to do it with VBA. Re-ask the question in the Excel-Programming forum and you'll get a useful answer, I think—if, that is, you're open to a VBA-macro solution.