Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Long time .... ok no tears. Problem: I would like to write Function with many argument: array, range, string, double etc, Public newarray() as String Function fillArray(varArray1() as Variant, _ optional select1 as Range, arg1 as Single) dim i as single for i=0 to 5000 newarray(i)=i+arg1 next i end Function I call this function with Sub Procedure sub firstsub() fillArray fillArray, end sub I'm siting many weeks and nothing, I read many FAQ, but all post have only one (array) argument. tx for help Witek *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA function for "Mean" using Array as argument | Excel Worksheet Functions | |||
Passing an array as argument for custom Function | Excel Programming | |||
Passing a string aray as an argument to a function ?....Help! | Excel Programming | |||
Range as argument in function | Excel Programming | |||
Passing an Array of User-Defined Type to an Argument of a Function | Excel Programming |