Thread: compile error - expected an array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
  
Posts: 2,069
Default compile error - expected an array
didn't Dim my variable correctly :)

"John" wrote:

Here is the code and I am getting a compile error...

any ideas?

For a = Dates.Count To 0 Step -1
DTadj(a) = Application.WorksheetFunction.workday(Dates(a), 1,
Holidays) - Dates(a)
Next
Reply With QuoteReply With Quote