Select Certain Cells within Range

Hi All,

Thanks Kvsrinivasamurthy, I presume your code will just select any cell on "MySheetName" that has the value "#N/A Requesting Data..."?

Richard at the moment I think I am effectively doing that, I have a cell Sheets(MySheetName).Range("A3") that has:

• IFERROR(IF(B6="#N/A Requesting Data...",1,0),0)+IFERROR(IF(D6="#N/A Requesting Data...",1,0),0)....

If Kvsrinivasamurthy code will just select any cell with "#N/A Requesting Data..." thats even better and will help with some other things.

In my original code I have;

   If c.Value = "#N/A Requesting Data..." Then
            Sheets(MySheetName).Calculate

Is it possible to just re-calculate the selected cells each time instead of the whole sheet?

Thanks