check if worksheet exists

How can I check if a worksheet exists before trying the access it? I've been
using the if text on an iserror for an indirect function, but this causes the
calculation to be very slow when entered into many cells.

It sounds like the sheet is slow because each cell with the formula is
checking the hard disk for the file. Try putting the sheet check into just
one cell giving say 0 for non-existing & 1 for existing, then use an if
condition in the other cells to check that cell?


--
Ian
--
"joeeng" <joeeng@discussions.microsoft.com> wrote in message
news:152E13AB-8E84-40BE-9086-FBF9A4D1D698@microsoft.com...
> How can I check if a worksheet exists before trying the access it? I've
> been
> using the if text on an iserror for an indirect function, but this causes
> the
> calculation to be very slow when entered into many cells.

It sounds like the sheet is slow because each cell with the formula is
checking the hard disk for the file. Try putting the sheet check into just
one cell giving say 0 for non-existing & 1 for existing, then use an if
condition in the other cells to check that cell?


--
Ian
--
"joeeng" <joeeng@discussions.microsoft.com> wrote in message
news:152E13AB-8E84-40BE-9086-FBF9A4D1D698@microsoft.com...
> How can I check if a worksheet exists before trying the access it? I've
> been
> using the if text on an iserror for an indirect function, but this causes
> the
> calculation to be very slow when entered into many cells.