Modify input range to a function

[axed]

Hi,

I have a vba function, I am giving it a matrix as input. I am however unable to modify the matrix within the function. Below is my function . Could you please help.

Function MaxDrawdown(A As Range)
A(2) = 0 'This does not work for me
End Function

Thanks in advance.

 

[shg]

If you are using that as a user-defined function (a function used in a cell formula), that won't work. With some odd exceptions, all a UDF can do is return a value to the cell in which it appears.

 

[axed]

Thanks, yea, its a UDF. Do you think the only way to go about this it is to create a copy of the input range matrix and then modify the copy. Since I need to perform operations on the input matrix to return output.

 

[shg]

You can read it into an array:

Function MaxDrawdown(A As Range)
    Dim avd As Variant
    
    avd = A.Value
    avd(1, 2) = 0
    ' carry on ...
End Function

 

[axed]

Thanks a lot.