Hello All. Thanks A lot Again To All you Monks for resolving the issue.

Davies thanks a lot. Your pointer to excel indexing proved too good.

Further one thing which actually resolved my problem is 'suppressing confirmation dialogues'. Sheets which are not blank, will prompt for confirmation before deleting these sheets. I suppressed this dialogue using following code & the problem was long gone.

And yes, 'll take care not to put titles in CAPS in future.(:-)