Subscript Out of Range - Copying from workbook to workbook

[emyyra]

I'm pretty new to VBA, so I'm not too familiar with the errors and exact coding rules. I'm getting a Run-time error '9': Subscript Out of Range when I use this macro:

Sub CopyStuff()


Range("d4:I15").Copy
Workbooks("C:\Users\emyyra\Desktop\Random Thing.xlsm").Worksheets("Myyra").Range("d4:I15").Paste


End Sub


'Any suggestions would be appreciated. Thanks!

 

[dmt32]

Dave,
Yes! It does work! Thank you very much! I appreciate it!

Glad it helped.

Dave