Excel VBA - code works with Microsoft but not Apple - Help Required

Hi, I have set up a tool in Excel that has worked for months in Microsoft Windows.

The piece of VBA code when run on Apple fails at the following line of code

Columns("U:U").Select
Selection.Find(What:="1", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=False).Activate

Does anyone know why this would be and what the alternative code would be that would work for Apple?

Or is it a settings issue?

Thanks in advance
Jeff

Perhaps someone who knows VBA better than I can chime in here.... but, VBA code from Windows needs to be recompiled in order to work in the Mac version of Office. That goes for VBA code used in Excel, Word, or PP.

Thank you chscag. Appreciate the response

I found out later on that it worked for someone with Apple Mac who had the most recent version of Excel installed. We're going down that route

Cheers
Jeff