Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Here is a small segment of my code : " Sub SeedOPErrs() Dim a As Collection a = rFunction() ' <----VBA editor returns an error "Argument not optional" ' when I attempt to run SeedOPErrs End Sub Function rFunction() As Collection Dim a As New Collection a.Add "GT" rFunction = a End Function " What is wrong with the code above ? Why is there an error "Argument not optional" ??!! I stared at my screen for hours ...and i still cannot figure out !! Thanks in advance !!! Regards, Adrian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to cast com object (interop) | Excel Discussion (Misc queries) | |||
Unable to access GridLines in Microsoft Graph Object [URGENT] | Charts and Charting in Excel | |||
Unable to add references to Calendar control and outlook object | Setting up and Configuration of Excel | |||
CombBox - Object of What Collection? | Excel Programming | |||
unable to create embedded object on a userform | Excel Programming |