find a specific cell from the entire worksheet

C

Cindy

hi
there are more than 80worksheets and i need to know which sheets have a
blank cell for C6 from the entire worksheet.
any help would be appreciated!
 
J

JMB

You could use a macro to do that:

Sub Test()
Dim wksTemp As Worksheet
For Each wksTemp In Worksheets
If wksTemp.Range("C6").Value = "" Then _
MsgBox wksTemp.Name
Next wksTemp
End Sub


Or, if by some unlikely chance your sheets were named Sheet1, Sheet2,
Sheet3, etc. you could use

=INDIRECT("Sheet"&ROW()&"!C6")=""
in the first row of a worksheet and copy down to row 80.
 
Top