VBA Find method errors on Excel Mac 2011

0
No votes yet
Reputation: 10
Asked 2 years ago.
297 View(s)
VBA Find method errors on Excel Mac 2011

The following method is working just fine in Excel for Windows but on the Mac i get a 448 runtime error "cannot find argument"

Set aCell = Worksheets(SheetName).Rows(1).Find(What:=HeaderName, LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate

Any ideas?

Delivery Time: 3 hours.
Question Category: Programming.

Place Your Bid

Place Bid
Shen Smith
Reputation: 99
Free
Deliver in: 3 days

Tutor Answer

You must be login to view answer.