Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating "Business Hours"

Status
Not open for further replies.

Besteed

Technical User
Dec 30, 2015
1
US
thread705-1207464

A couple of questions about the code in this closed thread...it seems to be just what I'm looking for, but I'm getting "User-defined type not defined".

> Why is this line commented out?
' ReDim MyDates(dtEnd - dtSt + 1)

> Where do I put this? I've tried it in the same module as the rest of the code, and a separate module. No luck.
Private Type MyDtHrsType
MyDate As Date
MyHrs As Single
End Type

Thanks.
 
Because in the original procedure, the Redim occurs in a loop further down in the code.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top