<Out of Context> Error thrown in VB Basic User Defined Function

[grs]

I am simply attempting to set the value of a cell using a function I've written in visual basic. Reading values from the cell all work correctly (second image below) but setting the Value property continually throws an <Out of Context> error in the watch window. I've not had this problem previously in code I've written in earlier versions of Excel and am stumped.

In the first image the code is being called in cell B63 and is attempting to reset the value of cell B60.

In the second image the code has been called and you can see the values of the local variables in the Locals window along with the value of the B60 cell in the Watches window.

In the third image I've stepped through the line that should set the value of Cell B60 to 2 and receive the <Out of Context> error.

Any help would be appreciated.

 

[Micron]

I don't suppose the sheet error message says something like "a value used in the expression is the wrong data type"? In that case, perhaps caused by your function returning a string but your value of 2 is numeric (".Value = 2). I'd start by declaring the function return type as variant, or perhaps integer or long. However, variant shouldn't fail if the return value is ever a string when you expect a number, or is null or zls, but declaring return type as integer or long probably will fail in those cases.

 

[grs]

The error message is shown in the Watches area in the 3rd image. The function is returning a string (last line of code sets ClearValue to a string) but execution of the code does not get this far as the function fails on the line that is attempting to set the Value property equal to 2 and does not execute any line beyond that point.

 

[Fluff]

A UDF cannot change the value of another cell.

 

[RoryA]

A UDF in a cell cannot alter the value of a different cell. (there are workarounds but it is, in my opinion, a bad idea as it makes your workbook extremely difficult to audit/maintain)