Code fails depending on the order in which it is run

[dflak]

I would like to attach the full workbook, but there is too much sensitive data that I can’t sanitize it.

I have two subroutines as indicated below:

Please Login or Register  to view this content.

If I run RunPct, first it runs perfectly. Then if I run RunQty, it fails.
If I run RunQty first, it runs perfectly. Then if I eun RunPct, it fails.

Both subroutines fail on the same line in CopyMonth:

Please Login or Register  to view this content.

I get a runtime error 1004 – Method Range of object worksheet failed.

shD is defined and LRowD is defined and they point to valid ranges on the spreadsheet.

Anyone have any idea why the same code run with the same parameters fails if another routine is run first? ShD points to either a percent sheet or a quantity sheet, and yes, the sheets are there. The sheet that gets pointed to is set by the parameter passed.

[CK76]

This line.

Please Login or Register  to view this content.

First Cells object is unqualified. change it to shD.Cells().

[dflak]

Now you know why I enlisted another set of eyeballs. I had just put this one away to look at later - the problem with both my code and my writing is that it says what I meant to say whether it actually says it or not. I have to let it age to debug it .

The miracle is that it worked at all.

Thanks for the catch. That seemed to be the issue.