View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dan Hatola Dan Hatola is offline
external usenet poster
 
Posts: 42
Default Setting a value is slow

What event/trigger are you using to call the function?

" wrote:

Hi,

I've wrote a function to calc some part of a worksheet, but when I set
a value in a cell this is really slow. If I check if the value have
changed before setting it, my function run pretty fast (My values
change rarely).

The ScreenUpdating And EnableEvents are setting to false, should I set
another thing to solve my problem?

Thanks

Luc