=cell("row") ... changes depending on what cell i click? HELP!

[tripflex]

Alright so if i put the above code into say the first five cells of my
workbook, they all have the same number in them?

I want each one to mimic what row it is in so it should be 1,2,3,4,5 but for
some reason all of the cells say 5 if i have 5 or 4 if i have 4, etc

Anybody know why it is doing this? Thanks!

 

[FSt1]

hi
try this =cell("row",A1)
without a reference i think the formula references the activecell. not 100%
sure on that.

Regards
FSt1

 

[Bob Phillips]

Try

=CELL("row",A1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Sheeloo]

Use
=ROW()

If you want to you cell then use it like this
=CELL("row",A1)
it will give you the row number of the cell A1