The following method is working just fine in Excel for Windows but on the Mac i get a 448 runtime error "cannot find argument"
Any ideas?![]()
Set aCell = Worksheets(SheetName).Rows(1).Find(What:=HeaderName, LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate
Bookmarks