I have the following code:


Please Login or Register  to view this content.
I am trying to count numbers in cells from different worksheets to get an average. however, in some of the cells it is collecting the figures from (eg DFigA = Sheets("wc 11.06").Range("M5")) is a formula that displays a percentage. In some of the cells, it will be '#DIV/0!' and therefore when I run the macro I get a type mismatch.

Is there anyway I can get this to run and just ognore cells that contain 'DIV/0!'?

thanks
Damian