c is not the ActiveCell. You would have to c.Activate c to be the
ActiveCell. Acivate is rarely necessary and ruins performance, so avoid it.

Address of ActiveCell = ActiveCell.Address
Address of c (within your loop) = c.Address
(why do you say c.address doesn't work? Keep in mind that Address returns
"$A$1", not "A1" if you are doing a string comparison)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Milind" wrote in message
...
Hello All
Your answers are right, but I think I could not put it right.
How to get the Activecell's address? Then how to use it in conjunction
with Range, Address etc.? Also how can I use the MsgBox to show it so that
I know the program flow is correct? Also, when I say
For each c in Worksheets("sheet1").Rows("5:5").Cells
if c.value = 50 then
...
what should I write in for c.range, c.address ? [I was wondering when
c.value works why not c.range or c.address?]
Thanks
Milind