VBA: Reference Dynamic Range From an Inactive Sheet

[Elfear]

I'm running into a brick wall trying to autofill some formulas on an active sheet with a dynamic range from an inactive sheet. The following code works great if the referenced dynamic range is on the active sheet:

Range("AS2").AutoFill Destination:=Range("AS2:AS" & Range("AQ" & Rows.Count).End(xlUp).Row)

Any idea how I would go about autofilling formulas on the active sheet for columns A thru J based on the # of populated rows on the "Input" sheet?

 

[Fluff]

How about something like

Range("AS2").AutoFill Destination:=Range("AS2:AS" &[COLOR=#ff0000] Sheets("Input").[/COLOR]Range("AQ" & Rows.Count).End(xlUp).Row)

 

[Elfear]

Worked great! Thanks!

 

[Fluff]

Glad to help & thanks for the feedback