Good Evening All
Could you please help. I have created a macro with the following code:
Range("H2"
.Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=RC[4]/RC[-1]"
Selection.AutoFill Destination:=Range("H2:H4893"
Range("H2:H4893"
.Select
This code should have done a simple formula of =L2/G2 and then copied the formula using autofill. It works on the first cell, but then just copies that cells result down the column.
The L and G columns are copied from another sheet, Will that make a difference?
Regards
Jupops
Could you please help. I have created a macro with the following code:
Range("H2"
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=RC[4]/RC[-1]"
Selection.AutoFill Destination:=Range("H2:H4893"
Range("H2:H4893"
This code should have done a simple formula of =L2/G2 and then copied the formula using autofill. It works on the first cell, but then just copies that cells result down the column.
The L and G columns are copied from another sheet, Will that make a difference?
Regards
Jupops