Forum Discussion
Solved
Issue in VBA Function to copy the formula result in one cell and paste as a value into another cell
The Function below copies a formula result from one cell and pastes it as a value into a different cell in the same worksheet. I expected to store this Function in an .xlam file in order to avoid sav...
- Functions called from a formula in a cell cannot make changes to any other cells, they return their result to the cell that uses the function in its formula.
Functions called from a formula in a cell cannot make changes to any other cells, they return their result to the cell that uses the function in its formula.
@Jan Karel Pieterse Thank you. It looks like I will need to save my template as a macro-enabled file. Or, continue to manually copy the formula cell and paste it as a value.