View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] luc.langlois@cdware.net is offline
external usenet poster
 
Posts: 6
Default Setting a value is slow

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