On Tue, 03 Jun 2008 19:01:10 -0400, Ron Rosenfeld
wrote:

I would define the Sheet name, for this example, as everything between the "]"
and the single quote. If you also want to capture the single quote, then
change the "'" to a "!".

That should read " delete the "'" "
--ron