If Sheet Exists Error

[ptmuldoon]

I'm trying to test if a Sheet Exists, and if it does exits to do some additional code/work on it. Any reason why the below fails with a 'Subscript out of Range' Error when the sheet in question is missing?

If I change the Sheet name to something that does exists, the code and msgbox returns correctly. But when the sheet being looked for is actually missing it gives the error?

Please Login or Register  to view this content.

Edit. I think I understand now. This is because it is looking at the ActiveSheet only? And you need to actually loop through the workbook to check if the worksheet exists?

[Faridwahidi]

Hi ptmuldoon,

you may try this,

Please Login or Register  to view this content.

If this helped you, please add reputation to me

[Ron Coderre]

I use this:

Please Login or Register  to view this content.

Is that something you can work with?

[LJMetzger]

Hi,

The subscript Out of Range runtime error is generated when the Sheet does not exist.

I use the following function:

Please Login or Register  to view this content.

Lewis

[ptmuldoon]

Both are good solutions. Code is running now through about 100 files to see if the sheets exists and pull out some data.

[Faridwahidi]

Hi pthmuldoon,

Thanks for rep'