Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 119
Default UDF interaction with other macro causes Error 1004

I think I may be on to what may be the cause of this error, but I'm not sure.
I think that I'm hitting the issue where UDFs are not allowed to modify other
cells in the WS. It appears that when I actually have a UDF called from a
cell, it sets up the condition that my other function that is invoked by the
Worksheet_change event is no longer allowed to alter cells. I'm not sure what
cells it would be allowed/not allowed to change.

it might be some how related to the order the functions are called when the
WS recalculates or some other condition.

I changed the WS_change called routine so it sets public global vars and had
one set of cells that I changing get the global values and the error didn't
happen.

From my debug.print statements, I don't see why the WS_change invoked
routine should get caught up in the UDF limitation, or why the WS_change
routine is allowed to alter cells when there is no UDF on the WS.

Any ideas for a workaround? Any ideas how to allow my WS_change routine to
alter cells?

Thanks.


Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"