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: 2
Default different value for setting with breakpoint vs regular running code

Thanks Mick. The situation is confusing at best - thanks for taking a stab at it.

I think I understand what you're getting at. Essentially, if conditions are one way, change the secondary axis, if they are another way, change the primary axis. Not a bad idea. The issue is that I have no way of testing or recognizing what condition I am in.

When it comes down to it, I'm grabbing the min of the primary axis, and setting the min of the secondary axis to that same value. Somehow, however, on certain users' machines, when the code is finished running, they get a chart with axes with different min's.

So, I stepped into the code to investigate why. I came upon the line of code which "should" actually set the min's equal to each other. I discovered that if I put a breakpoint anywhere before this line of code, and then press F5 (having done nothing else), I get axes with the same min value. If there is no breakpoint, or it comes after the said line of code, then I get axes with different min's.

I went even further, and verified that the said line of code actually picks up a different value for the min of the primary axis depending on where/if there is a breakpoint.

I don't know if that was any clearer. Any ideas anyone?

Tyler
 
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
different value for setting with breakpoint vs regular running code daddy-o Excel Programming 2 March 7th 11 01:40 PM
Code stops for one user, like it has a breakpoint Barb Reinhardt Excel Programming 1 December 18th 09 05:09 AM
Setting timer to run macro at regular intervals Mike H Excel Programming 0 January 10th 09 05:18 PM
need breakpoint to stop code Souris Excel Programming 1 February 22nd 08 07:00 PM
Ignore breakpoint when running a macro hmm Excel Programming 5 January 1st 08 12:51 PM


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