Also; go Tools Options in the VB editor and check "Require variable
declaration". This puts Option Explicit on top of your new modules.
Backside is (surprise) that you must declare all variables and be careful
with ypur spelling, bonus is better intellisense and more helpful error
messages.

HTH. Best wishes Harald

"John" wrote in message
...
Where do I find documentation that will tell me what all the Excel VB
coding
functions are?

Is there some way I can get or use the Excel 2007 VB editor to be a little
more helpful producing correct code?

This might help me to figure out more things on my own and not bother
forum
experts so much. I'm pretty green at this VB thing, but am a good
learner.

Thx for your help, John