Can't use workday( in macro

[George J]

Can anyone tell me what i am doing wrong?

Dim vardue As Date
Dim varstart As Date

vardue = Cells(i, 7)
varstart = workday(vardue, -3)

I have checked that i have the analysis toolpack activated, and also the vba extensibility library.

What am i missing??

thanks
George

 

[TheNoocH]

Note: not all worksheet functions are available in VBA
see this topic in the VBA Help
List of Worksheet Functions Available to Visual Basic

You may want to create a formula for workday in your spreadsheet then pull it from there...

eg...

Dim vardue As Date
Dim varstart As Date

vardue = Cells(i, 7)
varstart = Cells(i, 8)

hope that helps

 

[Andrew Poulsom]

First, make sure the "Analysis ToolPak - VBA" Add-In is installed (Tools|Add-Ins). Then click your workbook in the VBE and add a reference to atpvbaen.xls (Tools|References).

 

[George J]

Didn't have the atpvbaen.xls selected.

Many thanks
George