Thanks for the help of Norman and Dave at
http://msdn.microsoft.com/newsgroups...=en-us&m=1&p=1

Now, I have another follow up question about formula in Excel worksheet.

I got a "No Cells were found" error if I use Active Sheet.SpecialCells()
method to retrieve all formulae on a worksheet. I suspect that this error
happen because I try to retrieve "nothing" if a worksheet have NO formula at
all. However, how can I skip this worksheet and then go on to next
worksheets?

Thanks,
Peter