Program skips for loop

[ShieBoon]

Hi all,

When i run my codes, my program skips the for loop and goes on to the next line after the loop. What happened??

Using excel 2003

Thanks
Shie Boon

 

[jim may]

why not post your code?

 

[ShieBoon]

Alright

NextRecord = 0 ' set global variable back to 0 to solve deletion problem
For x = 1 To FinalCol
Call NextBlankVisCell(CInt(x))
Next
MsgBox (NextRecord)
Load Insert_New_Record_Form
Insert_New_Record_Form.MultiPage_Insert.Value = 0
Insert_New_Record_Form.Show

When i run the program in 'step into' mode, it skips the For loop~!

 

[jim may]

So how does FinalCol get it's value? If FinalCol is greater than 1 then the loop is taking place.
As you step through (using F8) is the cursor jumping to the NextBalnkVisCell routine?

 

[Steeviee]

Are you sure that you have set x to 1 before this section of code. If you have the locals window open whilst stepping through, you should be able to see what value x (and your other variables) are at during each step.

 

[ShieBoon]

Hi Jim and Steeviee, thank you for your replies and my apologies for the late reply.

To Jim: FinalCol is a global variable i've declared. It has a value of 32. Right before i posted this thread, I encountered a weird situation where the cursor skips the for loop in step mode. (Yellow Highlighted "For x = 1 To FinalCol" jumps to Yellow Highlighted "MsgBox (NextRecord)") Whereas after when i step through it again, the for loop undergoes. But i didn't change anything.

To Steeviee, I thought x = 1 to FinalCol already declares x as 1?

Thanks