VBA code and XLL
 

Hi,

I'm doing a sheet with VBA code to process data that has been get by a
user defined function that resides inside an XLL.

Here is my problem.

In my VBA code, I'm calling

Set rTemp =
Worksheets(...).Range(Worksheets(...).Cells(...,.. .),Worksheets(...).Cells(...,
....))

in short, I want to get a Range with data that has been get by my user
defined function.

The problem is that this call triggers a recalculation of my user
defined function which is a bit long.
Is there a way to block recalculation in VBA ?

Thanks

Nic