I am trying to help automate a tedious task and I think a user defined function would come in really handy. What I want to do is to have a function that takes a line number (or 1D array of that line) and a number and does some simple arithmetic on it. This is what I have tried so far, but it fails to compile:
REM ***** BASIC ***** Function CON(a, b) CON = a * b * a * (1 + (0.5*a)) * (1 - (0.15*a)) End Function Sub Main End Sub
‘a’ is the array, and I would have expected a to be cell Cn where n is the row number. ‘b’ is just a float.