View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Call another Macro

Since there are no arguments for the Update Sub, that is true. I was trying
to emphasize that if you use the CALL syntax, that the arguments must be
enclosed in parentheses. Conversely, if you don't use call, they should not
be enclosed in parentheses unless it is a function returning a value that is
used by the calling program.

--
Regards,
Tom Oglvy

"David" wrote in message
...
Tom Ogilvy wrote

Private Sub Commandbutton1_Click()
' My Code
Call Update()
End sub


Using XL2000 at least, I've found that Call Update works without the '()',
but I normally just use Update

--
David