AutoFill using r1c1 and variable row

[puskacpj]

All I can say, is I'm trying but getting a syntax error using r1c1 and tot_req_row which is a variable to the total number of rows:

Doesn't work:
Selection.AutoFill Destination:= Range(R2C8:R" & tot_req_row & "C8), Type:=xlFillDefault

This works:
Selection.AutoFill Destination:=Range("H2:H1140"), Type:=xlFillDefault

I've tried so many variations that I am TOTALLY LOST. HELP me I've fallen into the depths of vba and can't get out!

 

[VoG]

Try

Selection.AutoFill Destination:=Range("R2C8:R" & tot_req_row & "C8)"), Type:=xlFillDefault

 

[puskacpj]

I'm now getting RunTime error: 1004 Method range of object global failed

Selection.AutoFill Destination:=Range("R2C8:R" & tot_req_row & "C8)"), Type:=xlFillDefault

Thank you for helping me

 

[VoG]

Why not

Selection.AutoFill Destination:=Range("H2:H" & tot_req_row), Type:=xlFillDefault

 

[Norie]

What's Selection?

 

[puskacpj]

You're a STAR