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'

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1

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


On Apr 2, 2:51*pm, "tkraju via OfficeKB.com" <u16627@uwe wrote:
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'

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200904/1

Thank you madhu.

"muddan madhu" wrote:

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


On Apr 2, 2:51 pm, "tkraju via OfficeKB.com" <u16627@uwe wrote:
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'

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200904/1

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

=IF(AND(A1="raju",D1=""),"BLANK","")
--
If this post helps click Yes
---------------
Jacob Skaria


"tkraju via OfficeKB.com" wrote:

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'

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1