Error 9: Subscript Out of Range

[ChesireCat]

Hello all,

Here is the issue in point form:

- at my job, we use excel to create a journal entry and up load it into SAP for posting
- this is a journal entry file and if I add or delete a workbook tab that is either needed or not needed within the file, I get that famous
Error 9: Subscript Out of Range error and this kills the file
- I then have to grab another J/E file that works and delete the one with the error

I would LOVE to know about VBA to fix this range error. I am sure it's a common error but I can't seem to correct it.
I do know how to jump into a macro but that's about it.

Helllp!


Regards,
Rich

[Arkadi]

If the code refers to a sheet (tab), and you delete that, then you get the error. How to deal with that depends a lot on how you want to handle it. If it doesn't exist anymore, just ignore it? or is there a replacement to be used instead?... the options are quite long to list... it all depends on the requirements.

[ChesireCat]

Hello and thank you for your reply,

I am not sure what the code refers to as I have yet to learn how to read code.
The tab deleted was no longer needed.

When I delete or add a tab it obviously changes the range so I guess I need to know how to update the range.

I can post to code here if interested I suppose.


Regards,
Rich

[Arkadi]

The code would be a start...

There are 2 parts to a range... the sheet, and the actual range. When no sheet is specified, it is assumed to be the active one.