View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tommy[_7_] Tommy[_7_] is offline
external usenet poster
 
Posts: 2
Default Can't Update Cells from a Function?

I have a function for which I'd like to update some cells
programmatically. For the purposes of simplicity, I've
boiled the problem down to:

Function CellUpdt(InR as Range, OutC as Range) As Integer
' Do some processing with InR
...

' Update some spreadsheet cells
Cells(OutCell.Row, OutCell.Column) = "Value1"

' Return
CellUpdt = 0
End Function

The function is driven from the spreadsheet itself, ie.,
=CellUpdt(M24:P50,R7:R10).

I can't seem to get this work. In the debugger, when I
reach the 1st assignment statement, the program just
ends - no errors, no messages.

Anybody know what's wrong?

Thanks, Tommy