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: 1
Default Workesheet Calculate - strange behaviour and theoretical question...


Hi all,

I have the following strange thing happening in a Worksheet Calculat
code:

there are three pieces of code, each one indipendent and triggered b
certain events on the sheet. they happen in the order that they are i
the code (=the second cannot be without the first, the third withou
the second). i have used the following structu

SUB WORKSHEET CALCULATE
IF...
END IF

IF..
END IF

IF...
END IF

END SU

Now, if they are all together in the code only the first gets triggere
but not the second and the third, even with the events triggering them
If each of them appears in the code as standlone (second but not 1s
and 3rd etc) they all work!

Am I missing something??

Many thanks

B

--
bondcras
-----------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...fo&userid=2099
View this thread: http://www.excelforum.com/showthread.php?threadid=38565

 
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
Strange if(***) behaviour? Excel 2003 - SPB Excel Discussion (Misc queries) 6 August 6th 06 05:34 PM
Automation behaviour - strange but very useful Robert Chapman[_3_] Excel Programming 2 April 11th 05 09:43 AM
Strange behaviour Edgar Thoemmes Excel Worksheet Functions 1 February 8th 05 03:20 PM
Strange behaviour in VBA Help Michael Singmin Excel Programming 4 June 4th 04 07:06 PM
strange behaviour Patrick Molloy Excel Programming 0 September 4th 03 07:51 AM


All times are GMT +1. The time now is 04:04 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"