Thread: Why?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bruce Roberson Bruce Roberson is offline
external usenet poster
 
Posts: 47
Default Why?

I just lost my mind for a minute I guess and forgot to put
the word "sub" before the name... I guess I'm so bogged
down in logic right now trying to figure out my project,
that I made a goofy mistake that I shouldn't be making at
this point.

Thanks,


Bruce
-----Original Message-----
did you put in

Public Sub Summonth()

or

Sub Summonth()

or

Function Summonth()

or

Public Function Summonth()

(possibly replacing Public with Private)

--
Regards,
Tom Ogilvy


"Bruce Roberson" wrote in

message
...
I am in the VB Editor and have typed the name of a new
routine call Summonth()

When I key in "Summonth()" and then press enter, Visual
Basic keeps putting up the box "Compile
Error", "Expected:="

But I haven't keyed anything yet for it to object to on
that routine, so why is it making the red area the new
routine and highlighting that in Red letters? I haven't
done anything with it yet. Does it realliy have a

problem
with something in the previous routine?

Exasperated,


Bruce




.