run time error 9 subscript out of range

[Patriot2879]

Hi, i get a run time error 9 subscript out of range and when i debug it highlights in yellow my Uerform7.show can you help at all please to stop this, it happens when i copy data from another spreadsheet into my userform on the main one

 

[RoryA]

If the sheet is in the same workbook as the code, you should use:

With ThisWorkbook.Sheets("IN DAY LISTS")

 

[Patriot2879]

hi thanks for this it looks as though that has resolved the issue, much appreciated

 

[RoryA]

Glad we could help.