View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NateBuckley NateBuckley is offline
external usenet poster
 
Posts: 146
Default Passing Type Arrays

Firstly the important bits of code

Type aLocation
location as String
qty as Long
End Type

....

Private Sub CreateSheets()
Dim loc() as aLocation
....
loc = e.getBinLocations
....
End Sub

'Held in CSKU Class (e from above is a CSKU Object
Public Function GetBinLocations() As aLocation
GetBinLocations = binLocations
End Function

When running i get the error message, "Type Mismatch", on the line loc =
e.getBinLocations. Basically just want to grab an array of aLocation type and
assign it to loc which is an array of aLocation type.

No Idea why it won't work, is there anything I should be aware of when
passing an array of type?

Cheers for any help thrown my way.