CellRange as parameter in user defined function

[Rainer]

Hi,

I'm a beginner in writing user-defined functions with startbasic and my problem is to give a cell range to my function and use it there. Maybe somebody can give me an short example.

I want to check that the range has a width of only one column and get the value of the cell in the range with have the same row as the cursor is positioned. This value should be divided through the minimum value of the range and the result should the filled in the cell where the cursor is positioned.

Thanks for help
Rainer

[Villeroy]

X1 =$A1/MIN($A$1:$A$65536) [the first A1 with relative row reference]
You may want to read the tutorial on relative/absolute addressing in this forum's tutorials.

[Rainer]

Thank you for your answer Villeroy, but you don't hit my problem.

I want to give a cell-range into a user-defined function and calculate the minimum of the cell-range there.
I also need information about the cell the cursor is in. (at least row and column)

Help needed anymore
Rainer

[Villeroy]

As a matter of fact, any userdefined function --be it written as Basic macro or c++ add-in-- gets values. The application never passes range objects.
So your function would be called with references anyway:
X1 =MYFUNCTION($A1;$A$1:$A$65536)

This is how all spreadsheets use to work and I always recommend to use it just like that. Avoid all macros and userdefined functions in particular. For better performance, readability, ease of debugging, portability and compatibility.

[Rainer]

Hi,

I solved my problem. It was as Villeroy stated that no ranges are passed to functions. But They are passed as array and via LBound and UBound the number of cells in the array can be determined.

Thanks
Rainer

[Villeroy]

Hi,

I solved my problem. It was as Villeroy stated that no ranges are passed to functions. But They are passed as array and via LBound and UBound the number of cells in the array can be determined.

Thanks
Rainer

Yes, but there is no concept of "this cell", "this sheet", "this row", "this anything",...