| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
compile error - expected an array
It's for a different question.
John wrote: wow is that for my post? I am confused if it is.. "Tom Ogilvy" wrote: Public Type Material MatNum As Integer MatDate() As Date End Type Public matType() As Material Const MaxMaterials As Long = 12 Sub ABCEFG() ReDim matType(1 To MaxMaterials) For i = 1 To MaxMaterials ReDim matType(i).MatDate(1 To 10) Next End Sub -- Regards, Tom Ogilvy "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 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compile Error: Expected Variable or Procedure, Not Project | Excel Programming | |||
| Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
| compile error: Expected: = ...Why? | Excel Programming | |||
| Compile Error: Expected End Property | Excel Programming | |||
| compile error: expected variable or function | Excel Discussion (Misc queries) | |||
Threaded Mode
