Run-time error '9': subscript out of range

[nicko54]

Hi all,

I have a macro which was perfected by the good people here on this forum and all was running well.

I subsequently changed the file paths and file names, and updated the marco accordingly. I have obviously done something wrong as the marco no longer works and i am faced with the following error message "Run-time error '9': subscript out of range"

I am not sure why this is happening. I have attached the macro below...

Please Login or Register  to view this content.

any thoughts?

much appreciated,

Nicko

[nicko54]

i think i have made some progress. I hadnt changed the master excel sheet name to 'Data Dump', I have now done this in the macro and it looked like it was working, but now i am faced with another error "400"??? i dont know what this means or how to fix it.

Any ideas?

[shg]

MyPath should end with \ not /

What line fails?

[nicko54]

ok i changed that in MyPath, but I am still getting the error message.

I put in a Catch trap into the formula....

Please Login or Register  to view this content.

and the message box is telling me "The cell or chart you are trying to change is protected and therefore read-only.

To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Review tab, Changes group). You may be prompted for a password."

but the sheet isnt protected so I dont understand why this is happening???

Many thanks,

Nicko

[shg]

Take out the On Error statement and see what line of code fails.

[nicko54]

It fails on this line...

Rng.Copy wb.Sheets(1).Range("B1")


With a message box "run-time error '1004' application-defined or object-defined error"

[jeffreybrown]

Nicko,

I'm not sure shg is around, but in the meantime try...

Please Login or Register  to view this content.

Seems to work for me...