Thread: Why?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Why?

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