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

Regards
FSt1

"tripflex" wrote:

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!