I agree . . . a single word shouldn't trigger an error.
I have a question for you now. I also just started using
Excel 2003, and I have a puzzeling problem: My wheel mouse
won't scroll in any of the windows associated with Visual
Basic. It works just fine elsewhere. It's driving me
cookieputz! No one seems to know why, except there has
been some mention of a Universal Scrolling List and
exceptions thereto. So far I have been unable to find it.
Are you experiencing any scrolling problems?
-----Original Message-----
Todd,

I don't know about drawing tables (what, exactly, do you
mean by
"drawing tables"), but VBA doesn't and shouldn't raise an
error
if you enter a single word (assuming it isn't a reserved word
or ) on a line of code. VBA interprets this to be the name
of a
function declared elsewhere. It will raise a compiler
error if
no such function exists, but it doesn't raise an error as you
type in the code. This is the behavior in all versions of VBA.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Todd Huttenstine" wrote in
message
...
Hey guys

I installed Excel 2003 on my computer 2 weeks ago. It seems
kind of
unstable especially when it comes to making and drawing
tables.
Also is
there anything wrong with my VBA In it because if while
in any
sub I type
type any word such as the word "test" on a line by itself, I
dont get an
error. I thought on previous versions of Excel if I typed a
word on a line
byitself, it would turn red. I cant remember but thats
what I
thought
happened.

Does anyone have an opinion on Excel 2003?

Thank you
Todd Huttenstine




.