asked on

Invalid procedure call or argument when using other computers

Hi All!

I've been bugging by an error on my macro vba excel "invalid procedure call or argument".

This is the line of the code that has the error. Funny thing is, it's working fine on my laptop but when others try to use it, it give that kind of error. Any idea on how can I resolve this one? Thanks for the help!

strDate2 = Application.Workbooks("Audit Observation Monitoring System.xlsm").Worksheets("Approver").Range("B4")
With Application.Workbooks("Audit Observation Monitoring System.xlsm").Worksheets("Calendar").Range("B1:Z1")
Set rngIndex3 = .Find(What:=strDate2, LookIn:=xlValues) - here is the error
Application.Goto rngIndex3, True
d = ActiveCell.Column
End With

ASKER CERTIFIED SOLUTION

Roy Cox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jay Carmelo Cruz

ASKER

Hi Roy,

Thank you for your quick response.

I declared the strDate2 as string as when I tried to declare it as a Date it won't give me the result that I wanted. I also attached some screenshot of the excel file.

For the format, the excel file itself is saved on our shared folder. But only one people can use it at a time.

Jay Carmelo Cruz

ASKER

Hi Roy!

Actually, you are right. For some reason, the laptop of my colleague doesn't have date separator so I'm thinking that is the problem.

Thank you so much!

SOLUTION

Roy Cox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jay Carmelo Cruz

ASKER

Thank you so much! The problem had been resolved!