Jan 11 2023 11:32 AM
How do I copy a cell with Rand() function into another cell without the original cell changing numbers?
Jan 11 2023 01:06 PM
You could set Calculation Options on the Formulas tab of the ribbon to Manual temporarily.
But as soon as you set it to Automatic again, the formulas in both the source cell and target cell will be recalculated.
Jan 11 2023 01:07 PM
@HansVogelaar Thank you for your quick and helpful advise. It has helped a lot.