Copy/pasting from one workbook to another - Out of range error

Hello all,

I've been having a little trouble with something that should be simple, and I keep getting an error which I can't figure out.

I have a file with contacts in the "Supplier Contacts" tab. Under certain conditions, I'd like the range A1:F1000 in the current file to be copied to a master file which the user selects using an "Open File" dialogue. The master file is identical in structure to the file I'm working on (same sheets). Up to here, all is ok. But when I get to the pasting in the master file part, I get an Out of range error, and it's driving me nuts.

Here is my code (messy, I apologise beforehand):

Please Login or Register  to view this content.

When the macro gets to:

Please Login or Register  to view this content.

I get the "Subscript out of range" error, and I can't understand why.

I don't know if there are any errors after that line, BTW, as I can't get past the error above

Can anyone here see the error that is eluding me?

Thank you in advance for any advice.

-Isa

Please Login or Register  to view this content.

Use quotation marks around MasterFile is at least one correction. Not certain if there are more.

How about

Please Login or Register  to view this content.

Your other range references use ':'

Thanks to all of you guys, you're a great group of people.

The variable to refer to the workbook being opened resolved the problem. I also corrected the semicolon instead of the colon in my range, thanks for pointing that out.

It all makes perfect sense now, but I was pulling my hair out yesterday. Thanks for restoring my sanity

-Isa