UDF's (User Defined Functions - VB functions called from a worksheet cell)
cannot perform "actions" (select a cell, do formatting, save a file, etc).
Unfortunately .CurrentRegion is seen as an action by Excel. It seems that,
internally at least, Excel is doing a selection.

--
Jim Rech
Excel MVP