VBA not working for MAC

[Finalfight40]

Hi All

I am having an issue where i have a line for a macro which works for PC but not on mac.

The lines provided i'm pretty sure are causing the issue:

Set LookUpDate = ActiveCell
On Error GoTo DateNotFound1
Rows(ActiveCell.Row).Cells.Find(What:=LookUpDate, After:=ActiveCell, LookIn:= xlValues, LookAt:= xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate

Even tho the date is 11/06/2018 and is there, it will go straight to the error handling.

However when i replace LookUpDate in the find section, with "11/06/2018", it works. Can anyone advise me on this?

(Would copy and paste the vba from the MAC but cant access the internet from it at the moment so is typed out)

 

[Finalfight40]

Hi Mark

That did not work either.

I have just double checked and it definitely works on my PC.

If it would help to upload my workbook, i am happy to do so but could someone please let me know the best way to go about this.

 

[Finalfight40]

Also when removing the on error go to line i get:

run-time error 91

Object variable with block variable not set

 

[MARK858]

What happens if you change the CLng to CDate?
I won't be able to check the file as don't have a MAC in front of me today but you can upload the file to a free file hosting site like www.dropbox.com or www.box.com, Mark it for sharing and then post the link it provides in the thread and I am sure someone will look at it.

 

[Finalfight40]

What happens if you change the CLng to CDate?
I won't be able to check the file as don't have a MAC in front of me today but you can upload the file to a free file hosting site like www.dropbox.com or www.box.com, Mark it for sharing and then post the link it provides in the thread and I am sure someone will look at it.

Hi Mark

It still brings up the same error message.

 

[Finalfight40]

Thanks for the advice on sharing the workbook:

For anyone who may be able to help, please see link below:

https://www.dropbox.com/s/9yaseilktksjriw/Project Work Summary.xlsm?dl=0

 

[Finalfight40]

The macro results that are displayed in the second sheet "Summary" are from when i ran it from a PC and are correct.

However these results are different to when i would run it from a MAC.