debug modes learning

Hi All

I am trying to understand what these debug modes are all about, i Know its very essential in a coding which will help us.
But some one can tel me where and how we should use this. I have a long list of queries out of which few are.

Debug.print
debut.assert
Immediate window. (I know this is something which we use to see immediate results for your coding)

My code is below. which is a very small programme. where it just shows left,right of a string in the cells. MY query is where i can use the above two to options(debut print and debug asser) and understand how it helps. what is that in the immediate window should i type / paste to see the immediate results. have read articles from cpearsons, but while it comes to my coding i am confused.

Please Login or Register  to view this content.

Perhaps the link below will help

http://www.cpearson.com/excel/DebuggingVBA.aspx

Debug.Print just displays the contents of a variable or a cell.

Debug.Assert can be used to test a variable or cell and cause the code to stop. I must admit to never having used this ... And you certainly wouldn't want to leave it active in your code.

You can see the output from Debug.Print in the Immediate Window. Press Ctrl-G to open the Immediate Window pane if it is not showing in the VBE.


Regards, TMS

Originally Posted by TMShucks

Debug.Assert .... I must admit to never having used this ... And you certainly wouldn't want to leave it active in your code.

Snap!!!!!!!

@WasWodge: yes, and for a long time I didn't even know it was an option. But, even when I discovered it (I think, on Chip's web site), I have never found reason to use it. Other debug methods usually work well for me, like putting a Stop in the code, or adding a break point, and stepping through the code with F8.

Regards, TMS

a) It shows whatever you put after it (normally the result of a variable,a text string, result of a formula (see your adapted code below)).
b) yes
c) Can't think of a use for it but the easiest way would probably be to put in a counter to count the iterations. See x in your adapted code below.

Please Login or Register  to view this content.