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
|