Hello hello hello,
I'm trying to replace a formula within a Macro to optimise my code a bit.
Previously, this was written and references a workbook called Capacity that was already opened previously in the code:
Range("Z3:Z" & Lastrow).FormulaR1C1 =...