CODEWITHSUNDEEP
excelworksheet-functionvba
Peekay
Peekay

Reputation: 236

Trouble with WorksheetFunction in Excel VBA

I am trying to use Workday.Intl function inside a custom function and I am not able to get it work.Find screenshot attached enter image description here

I researched few questions on WorksheetFunction posted on this forum and tried using some of the suggested fixes but am not able to make it work. Am I doing something wrong? I tried substituting workday instead of Workday.intl but still does not work. Any suggestions? Thanks in advance.

Upvotes: 0

Views: 678

Answers (1)

tjibbe chris
tjibbe chris

Reputation: 160

It probably should be:

tempdate = WorksheetFunction.WorkDay_Intl( ...

Upvotes: 1

Related Questions