fill range with formula

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

This is my attempt to fill a range with formula "x".
Doesn't work.
Please help.


Range("A2").Select
ActiveCell.FormulaR1C1 = "X"
Selection.AutoFill Destination:=Range("A2:K10"),
Type:=xlFillDefault
 
J.W. Aldridge was thinking very hard :
This is my attempt to fill a range with formula "x".
Doesn't work.
Please help.


Range("A2").Select
ActiveCell.FormulaR1C1 = "X"
Selection.AutoFill Destination:=Range("A2:K10"),
Type:=xlFillDefault
Click to expand...

Well, I don't see a formula here, just the text value "X".

Try:
Range("A2:K10") = "X"
 
Back
Top