Maybe:

Dim msg As String
msg = "Blank cells found:" & Chr(10)
On Error Resume Next
msg = msg & Range("T11:T25").SpecialCells(xlCellTypeBlanks).Ad dress
On Error GoTo 0
MsgBox msg


Hope this helps
Rowan

"Sandy" wrote:

Hello -

I have cells T10:T25. I need to return the address in a MsgBox if the cell
is empty; e.g., say T11 and T15 are empty, in the messagebox it would refer
specifically to T11 and T15.

Any suggestions are greatly appreciated!
--
Sandy