VBA Syntax Help

[scottylad2]

Please Login or Register  to view this content.

the Code here is used in this forums VBA tips tutorials, If i copy and paste it, it works no problem and the words Do and Loop Until show up in Blue.

If i try typing the code, the word Do shows up in Blue as it does in the sample, but the Loop Until doesn't and the code fails. Is there a way to put the ending part of the syntax in via a selection drop down? I don't see it as an option and typing it's not working

Total novice at VBA

[shg]

Paste the code as it is when the Loop statement doesn't highlight, Scotty.

[Whizbang]

Do you mind pasting your hand-typed code? There has to be some mis-type that is preventing it from running.

[scottylad2]

Thanks for looking guys, but the code now appears to be working. Not sure but maybe I've put an errant space somewhere

[scottylad2]

Hi again, as a suplementary to my initial query, is there a way to inseet the Do and Loop Until without typing it? Ie is there dropdowns I've yet to discover that when i start a loop and insert the word Do....is there an automatic Excel generated step through to get to the Loop Until?

Really want to get my head round VBA but have started growing my nails in prep for the head scratching

As always, much obliged

[shg]

Typing is the way, Scotty. The VBE won't generate code structures like it will procedure signatures.