Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Parameters to Userdefined Functions
I want to create a userdefined function that will be assigned to parameters:
1. a cell containing a string, 2. a range of cells containing a variety of data. The contents of the string will be parsed and then compared with the range of data. The actual processing is not the problem, and I can easily create the passing mechanism for the string variable, but I dont know how to pass an area of the spreadsheet to the function. I have tried something like: function dosomething(names as string, paramarray DataArea) code here end func It compiles and seems to work, but nothing appears in the DataArea variable (or if it does I cant access it!). Any ideas gratefully received. Peter Morris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing several parameters to OnAction property. | Excel Discussion (Misc queries) | |||
passing arrays to user defined functions | Excel Worksheet Functions | |||
Passing parameters Cel Ref) to Sum function | Excel Discussion (Misc queries) | |||
Arrays parameters in Functions | Excel Worksheet Functions | |||
Passing Parameters through OnAction | Excel Programming |