Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Update tab function | Excel Worksheet Functions | |||
Don't Update Function | Excel Discussion (Misc queries) | |||
Cells w/ user defined function do not auto update | Excel Worksheet Functions | |||
Function Update | Excel Worksheet Functions | |||
How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions |