Sheet Array Help

[Eindrago]

I had to modify a macro that used the following Array

Please Login or Register  to view this content.

I needed to split it into two arrays as the number of columns change on a portion of the sheets. So I assumed I could just do this, but now only the "Minimum Rent Schedule" works. What did I do wrong.

Please Login or Register  to view this content.

[Eindrago]

Full Macro if needed

Please Login or Register  to view this content.

[ByteMarks]

Looks like you may be missing a couple of quotation marks? There are a few more potential ones, but it's hard to know without knowing the names of the sheets.

Please Login or Register  to view this content.

[Eindrago]

Unfortunately, that wasn't the issue, the Sheet Tab name is "JV-Travel, Prof Expenses"

[ByteMarks]

Try removing the On Error Resume Next and see if any errors arise.