Hi
For each c in worksheets("sheet1").Rows("3:3").Cells
if c.value = 50 then
....
MsgBox c.address
(I need this "c" address. When I use ActiveCell.Offset(5), to paste the
value, the result is 30 rows, then 35 rows ... I want to see what address
the program is referring to. When comparison is being done (c.value = 50)
how to get this cell's address and how to put it for others including
MsgBox. Please help
Milind