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!