Richard,

Why don't I have Excel VBA specific help info
There is no such thing. VBA is Visual Basic for Applications.
Excel is one of those "Applications"

your syntax error.
Your VBA Tools/Options are probably set to "Require Variable Declaration"
(which is a very good idea). Having this option selected will place
Option Explicit at the top of every module (which means that all your
variables
will have to be declared or you'll get an error).
I don't know what code Don gave you, but if you delete that top line
(Option Explicit), it should work. Better though would be to find
what variables that Don was using in the code he gave you and
declare them with a Dim statement.

John

"Richard Winston" wrote in message
...
First time opening up Excel 2002 (XP) VBA Editor to test a macro that Don
Guillet posted. I got a syntax error because a variable hadn't been
declared. I tried to bring up help on "Sheets" by hilighting the word and
hitting F1 but nothing happened. I clicked on Help and it only gives an
otions for 1) Microsoft VBA Help, 2) MSDN on the Web and 3) About
Microsoft
Visual Basic.


Why don't I have Excel VBA specific help info ? Was it just not installed
?

I've only ever done VBA stuff with Outlook on my 2000 machine at work, and
it provides Help for the Outlook objects.


I have the student edition of Office installed, by the way.