I am trying to find all blanks in my used range; my used range which goes
from E3:W330 and from Y3:AE330. I keep getting results like $AG$1, $AH$1,
$AI$1, $AJ$1, all listed in column AX (vertically). I am wondering how to
tell Excel just to look in E3:W330 and in Y3:AE330. Also, I am interested in
getting results in each row, such as $E$3, $F$3, $G$3 (all in one cell or in
one cell and then offset 0,1), if these cells are blank, and when all blanks
are found, shift down one row (offset 1,0) then identify any blanks in that
row. Does this make any sense? Any assistance would be sincerely
appreciated!

The code that I am using now is listed below:

Sub FindBlanks()

Dim rngBlanks As Range
Dim rngToPaste As Range
Dim rng As Range


On Error Resume Next
Set rngBlanks = Cells.SpecialCells(xlCellTypeBlanks)
On Error GoTo 0

If Not rngBlanks Is Nothing Then
'Worksheets.Add.Name = "Summary"
Set rngToPaste = Sheets("15.1 Detail - Madeup").Range("AX3")
For Each rng In rngBlanks
rngToPaste.Value = rng.Address
Set rngToPaste = rngToPaste.Offset(1, 0)
Next rng
End If
End Sub


This is just a sample; it doesn't really do what I want (as described above)

Kind Regards,
Ryan---
--
RyGuy