Simple code lines failing; error 9 confusion, For without Next...with next

[mikecox39]

I am testing; in the Immediate pane of the VBE, some of the example code in a book I am studying; in order to learn VBA.

Here are a couple that fail every time.

[/URL][/IMG]

I checked the Help option for error 9 but I didn’t understand it.

I’ve double checked the code; to make sure I entered it exactly as it is in the text, but it fails every time.

[/URL][/IMG]

This one has a "for" so why am I getting this error? Again, I double checked the example in the text and I have it written exactly as shown in the text.

Others, like “…comments.count” and “…Parent.address” work just fine.

 

[Norie]

There's nothing special about a temporary subroutine.

Like any other subroutine you would create it in a module, the syntax/layout is no different from a 'normal' subroutine and you can give it any name you want, as long as it complies to VBA naming rules.

As for the immediate window I don't really think it's the place for testing code.

PS You can quickly create a module by going to Insert>Module.

 

[mikecox39]

Like any other subroutine you would create it in a module, the syntax/layout is no different from a 'normal' subroutine and you can give it any name you want, as long as it complies to VBA naming rules.

As for the immediate window I don't really think it's the place for testing code.

I guess I really need to get a handle on that window

PS You can quickly create a module by going to Insert>Module.

Great, Thanks for that very helpful gem!

 

[hiker95]

mikecox39,

Try one of the items in my list - see if this sheds some light.

Turn up your PC's volume, then click on the below link:

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

 

[mikecox39]

mikecox39,

Try one of the items in my list - see if this sheds some light.

Turn up your PC's volume, then click on the below link:

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

Thanks; well done tutorial, I'm beginning to see the light (-:

 

[hiker95]

mikecox39,

I'm beginning to see the light (-:

It does take some time.

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.