find a specific cell from the entire worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cindy - 15 Nov 2006 05:16 GMT

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!

Reply to this Message

JMB - 15 Nov 2006 05:55 GMT

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.

> 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!

Reply to this Message