LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Type mismatch passing arrays via COM Dan Neely[_2_] Excel Programming 0 January 24th 08 03:38 PM
Passing Arrays to SUBs Bill Martin[_3_] Excel Programming 4 October 27th 06 02:37 PM
Passing arrays to VBA module Ralph K Excel Programming 1 November 20th 04 02:57 PM
passing arrays between functions in VBA Tom Ogilvy Excel Programming 3 March 1st 04 05:54 PM
Passing arrays to a subroutine Braden Craig Excel Programming 4 August 17th 03 05:54 PM


All times are GMT +1. The time now is 06:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"