CODEWITHSUNDEEP
excelvbamacos
Logick
Logick

Reputation: 331

Excel Doc macro yields "Named argument not found (Error 448)"

This code snippet runs perfectly fine in Excel on Windows.
But on OSX, it's giving an error Named argument not found (Error 448).

With Sheets("Colors")
        Set rangeFound = .Cells.find(What:=Resource, After:=.Cells(1, 1), LookIn:=xlValues, _
            LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
            MatchCase:=False, SearchFormat:=False)
End With

Upvotes: 0

Views: 1730

Answers (1)

teylyn
teylyn

Reputation: 35915

The Mac does not support the SearchFormat argument. Just omit and the code will run.

Upvotes: 1

Related Questions