View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Doug Glancy Doug Glancy is offline
external usenet poster
 
Posts: 770
Default Application.WorksheetFunction.Upper

According to help, that's not included in the worksheet functions available
to VBA. Use the VBA function Ucase.

hth,

Doug

"y" wrote in message ...
Function Test(Classe, osserv As Range, Dst As String, ParA, ParB) As

Single
...
Dist as string
...
Dist = Application.WorksheetFunction.Upper(Dst)
...

executing the "Dist = ..." statement VBA stops abnormally (without any

message)

Have you encountered this problem?

Alex.