LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default UDF recalc problem between sheets

My UDF "Func1" accepts a range array as one of its arg's
and passes this to "Func2" for intermediate processing,
works fine, except...

If I cause a recalc of udf in a formula on Sheet2 correct
result is returned. However if I switch to Sheet1, cells
with this udf show errors. If I recalc (F9) the errors
revert to correct results. Calculation is automatic and
nothing "volatile" in the wb.

What appears to be happening is when I recalc the udf in
Sheet2, udf formulas on Sheet1 are also recalculated, but
the array arg that relates to the udf on Sheet2 is passed
to "Func2" when the udf's on Sheet1 are being calculated,
hence the errors.

Recalc on Sheet1 corrects, and udf's in formulas on Sheet2
remain correct. I don't think there is a circular issue.

Debug.? .Caller.Address shows udf's in Sheet1 are
calculated before those in Sheet2, even if I initiate the
recalc in Sheet2. Re-ordering the sheets, and/or renaming
in different alphabetical order makes no difference. And
finally, initiating a recalc on any other sheet, even one
without udf's, causes errors in udf's Sheet1 but not in
Sheet2. (Same scenario in XL97 & XL2K)

Hope this is not too convoluted!

TIA for any suggestions
Sandy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't stop recalc [email protected] Excel Worksheet Functions 2 April 24th 09 01:29 PM
cell does not recalc revdeacon Excel Worksheet Functions 3 December 2nd 08 09:51 PM
Recalc Options in 2003? KMH Excel Discussion (Misc queries) 0 February 6th 06 04:02 PM
Automatic Recalc DME Excel Worksheet Functions 1 March 21st 05 08:05 PM
recalc question Bura Tino Excel Programming 2 July 10th 03 02:47 PM


All times are GMT +1. The time now is 07:35 PM.

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"