Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |