toWorksheets("sheet3").Range("B" & myColCheck & ":" & "E" & myColCheck).Copy Destination:=Worksheets("Sheet4").Range("B" & myColCheck & ":" & "E" & myColCheck)
Worksheets("Sheet4").Range("B" & myColCheck & ":" & "E" & myColCheck) = Worksheets("sheet3").Range("B" & myColCheck & ":" & "E" & myColCheck)
in B11 i will have the same formula and not=+F10*(1-F$5)
what i mean is that with copy and paste i adjust also the formula at the cell.=+F37*(1-F$5)
Worksheets("Sheet3").Range("B11:E11") = Worksheets("Sheet3").Range("B1:E1").Formula
if in B1 I have this formula
in B11 i will have the same formula and not
what i mean is that with copy and paste i adjust also the formula at the cell.
But not in this way,am I right or is there any solution?
Worksheets("Sheet3").Range("B11:E11").FormulaR1C1 = Worksheets("Sheet3").Range("B1:E1").FormulaR1C1