Hello all
Can anyone spot the mistake here please
The copying from one sheet to the other is working ok but it is leaving in the formulas instead of just the values
[Worksheets("Statistics").Range("B3:K22").Copy
Worksheets("Statistics Fixed").Range("B3:K22").PasteSpecial paste:=xlPasteFormulas]
Can anyone spot the mistake here please
The copying from one sheet to the other is working ok but it is leaving in the formulas instead of just the values
[Worksheets("Statistics").Range("B3:K22").Copy
Worksheets("Statistics Fixed").Range("B3:K22").PasteSpecial paste:=xlPasteFormulas]