View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Excel sum function IN VBA

Added comment:
Older versions being xl5 and xl95. WorksheetFunction was introduced in
xl97.

--
Regards,
Tom Ogilvy

"Jerry W. Lewis" wrote in message
...
Current versions will recognize
Application.Sum()
WorksheetFunction.Sum()
Application.WorksheetFunction.Sum()

Some older versions will only recognize
Application.Sum()

Jerry