So that means that any code in the UDF that affects highlighter movement or
adjusting the screen won't be performed?

"Tushar Mehta" wrote in message
om...
The only change a UDF can make is to update the value in the cell(s) in
which it is entered.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I've got a worksheet with several thousand records and a user-defined
function that can take some time to calculate. Each of these records has
this function applied to it, so the calculation time will be
substantial.
What I'm looking for is a way to have the function move the screen (or
the
highlighter) to the current cell being evaluated. That way, as the
entire
worksheet calculates, the user (me, actually) sees what cell is being
worked
on.

Thanks for any help...