Updating spreadsheet values using functions vba
First, you must load the If there is the possibility that you will have a procedure with the same name as an ATP function, you can prefix the function name with the library name to ensure you are calling the correct function.Excel does not allow cell values to be updated from a Function (as opposed to a Sub) but is there any workaround or back door method for this?Yes to Leith but that's not what I mean (though thanks) to Dave.Ok, here is a workbook attachment with a very simplistic example.If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
A volatile function will be recalculated whenever calculation occurs in any cells on the worksheet. Non-volatile functions are only recalculated when any of the function's arguments change. I'd really like to change a range of cells' actual values (rather than using formula results) as a result of a single function.To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.Then worksheet formulas like =Change These Cells(C2: E5, A2: A5 ) can change the values of cells other than the one holding the formula.Note that the Cells To Change argument and the Value For Cells should be compatible arrays. To change cells the way that you want, event code is needed.