fill range with formula

[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

 

[Dave Peterson]

or just:

activesheet.range("a2:k10").value = "X"

 

[GS]

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

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

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