Feb 04 2023 09:30 AM
Suppose I have formula in A1
I can do Range(“A1:A10”).FillDown
But how about if I want Excel fill formula of A10 ONLY? (bypass A2:A9)
Of course copy paste is a way. Any method beside copy paste?
thanks in advance
Feb 04 2023 01:26 PM
If the cell/range references in the formula in A1 have only absolute row references (i.e. with $ before the row numbers), you can use
Range("A10").Formula = Range("A1").Formula
But if there are relative row references (without $ before the row numbers, that won't work). Copy / Paste or Copy / Paste Formulas is the way to go:
Range("A1").Copy Destination:=Range("A10")
or
Range("A1").Copy
Range("A10").PasteSpecial Paste:=xlPasteFormulas
Feb 04 2023 04:16 PM