Find empty cell

[tkraju via OfficeKB.com]

my W/sheet data is;

Col A ---------- Col B-------------Col C ---------------Col D
raju -------------- 1234-----------------5678-----------------90
david------------- 098-------------------765-------------------432
raju-------------- 32----------------------76-------------------
james------------567--------------------uyt-----------------980
david---------------67-------------------567-----------------
I need a code -- match 'raju' from Column A and find which cell in Col D is
empty against 'raju'

 

[Jacob Skaria]

You dont need a macro to find this. Use this formula in col E

=IF(AND(A1="raju",D1=""),"BLANK","")

 

[muddan madhu]

try this,
cell address will be shown.

Sub match_it()
Dim i As Integer
Rng = Cells(Rows.Count, "A").End(xlUp).Row

For i = 1 To Rng
If Cells(i, "A") = "raju" And Cells(i, "D") = "" Then
MsgBox Cells(i, "D").Address
End If
Next
End Sub

 

[TUNGANA KURMA RAJU]

Thank you madhu.

try this,
cell address will be shown.

Sub match_it()
Dim i As Integer
Rng = Cells(Rows.Count, "A").End(xlUp).Row

For i = 1 To Rng
If Cells(i, "A") = "raju" And Cells(i, "D") = "" Then
MsgBox Cells(i, "D").Address
End If
Next
End Sub