AutoFill using Cells or R1C1 in a formula

[288enzo]

I'm trying to use Cells more these days over Range, and have dipped my toes into R1C1.

I'm using AutoFill, and what I have encountered is when using R1C1 the referenced cell is locked, similar to using anchors.
When I tried Cells in the formula I receive "#NAME?".

I'm trying to learn other options other than Cells(5, 10).Formula = "=Y5", maybe that's the best solution?

LR = Cells(Rows.Count, 1).End(xlUp).Row
Cells(5, 10).Formula = "=" & Cells(5, 25) or Cells(5, 10).FormulaR1C1 = "=R5C25"
Cells(5, 10).AutoFill Destination:=Range(Cells(5, 10), Cells(LR, 10)), Type:=xlFillDefault

Thank you

 

[Fluff]

What exactly are you trying to do?

 

[288enzo]

What exactly are you trying to do?

LR = Cells(Rows.Count, 1).End(xlUp).Row
Cells(5, 10).Formula = "=Y5"
Cells(5, 10).AutoFill Destination:=Range(Cells(5, 10), Cells(LR, 10)), Type:=xlFillDefault

Copy the values in column Y and paste them into column J, starting at row 5 and ending at the Last Row.

I know how, I was curious about alternatives using Cells or R1C1 in the formula.

Thanks

 

[Fluff]

Ok, how about

Range(Cells(5, 10), Cells(LR, 10)).FormulaR1C1="=RC25"

 

[288enzo]

Ok, how about

Range(Cells(5, 10), Cells(LR, 10)).FormulaR1C1="=RC25"

That's a neat trick, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.