Hi Peter,

if Cells.SpecialCells(xlCellTypeFormulas) is nothing then ....

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Peter" <Peter@discussions.microsoft.com> wrote in message news:1AFE770E-9E5A-4F7B-9490-50F14EADBBA6@microsoft.com...
> 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