View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curious[_6_] Curious[_6_] is offline
external usenet poster
 
Posts: 22
Default Use IF in a Function

When testing this function, I encountered "Invalid quantifier" message
and the highlighted word is "InvoiceNote.Find".

Function AccruedBillable(State As String, InvoiceNote As String) As
Variant

Application.Volatile (True)

On Error Resume Next

If InvoiceNote.Find(What:="Billable", _
LookIn:=xlFormulas, _
LookAt:=xlPart, MatchCase:=False, SearchFormat:=False) Then

Select Case State

Case Is = "ME"
AccruedBillable = 400

Pease shed a light on how to fix it. Thanks in advance.

H.Z.