My code isn't working and I don't know why

[andy7172289]

The code below stops when it gets to the second row of the first section. Can anyone tell me why? I've double checked all the tabs have the correct naming conventions...

LastRow = Sheets("RR Master").Range("A" & Rows.Count).End(xlUp).Row
Sheets("RR S&C").Range("A2").Select
Selection.AutoFill Destination:=Range("A2:L" & LastRow)

Sheets("RR PL").Range("A2").Select
Selection.AutoFill Destination:=Range("A2:I" & LastRow)

Sheets("RR Validation").Range("A2").Select
Selection.AutoFill Destination:=Range("A2:J" & LastRow)


Thanks guys, problem solved. The issue now lies with the 'Selection.AutoFill Destination:=Range(A2:I" & LastRow)'

 

[dhookom]

I believe you need to first select the sheet and then the range.

 LastRow = Sheets("RR Master").Range("A" & Rows.Count).End(xlUp).Row
[highlight #FCE94F] Sheets("RR S&C").Select[/highlight]
 Sheets("RR S&C").Range("A2").Select
 Selection.AutoFill Destination:=Range("A2:L" & LastRow)

Also, consider using TGML tags to format your code. It is typically much easier to read.

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[SkipVought]

You need not select anything...

LastRow = Sheets("RR Master").Range("A" & Rows.Count).End(xlUp).Row
 Sheets("RR S&C").Range("A2").AutoFill Destination:=Range("A2:L" & LastRow)

However, on what sheet is your destination range?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]