Getting Run-time error '9' Subscript out of range on VBA script

[amclaurin]

Hi there!
Can someone please help me with the code below? I am simplely setting values from several worksheets to update into one (really copying). I get the "Run-time error '9' Subscript out of range on VBA script"on the lines that are 'not commented out'. The lines that are commented it out seem to have set/copied correctly. What should I do?

Sub CopyPerThreadValuesForSites()

'Worksheets("Integration").Range("I3:Q3").Value = Worksheets("SS").Range("F61:N61").Value
  Worksheets("Integration").Range("I6:Q6").Value = Worksheets("MS").Range("E65:M65").Value
'Worksheets("Integration").Range("I9:Q9").Value = Worksheets("WS").Range("F72:N72").Value
  Worksheets("Integration").Range("I12:Q12").Value = Worksheets("DS").Range("E66:M66").Value
'Worksheets("Integration").Range("I15:Q15").Value = Worksheets("VL").Range("D54:L54").Value
'Worksheets("Integration").Range("I18:Q18").Value = Worksheets("SO").Range("E73:M73").Value
'Worksheets("Integration").Range("I21:Q21").Value = Worksheets("SR").Range("E66:M66").Value

End Sub

Thanks,
A

 

[Norie]

Have you checked that you have sheets named 'SS', 'WS', 'VL' etc in the active workbook when you run the code?

 

[amclaurin]

Yes, they are there.

 

[Norie]

No leading/trailing spaces in the sheet names?

 

[amclaurin]

Hi Norie,

I got it...I had a space in each tab! Corrected it and it's working perfectly!

Thank you so so much!