Thank you for your suggestion, but I don't think it will help me.
I'm trying to get my current formula (used to to create row numbers):
=(INDEX(A:A,ROW()-1,1)+1)
to show consecutive numbers even if a row his hidden. For example with my current formula if row 4 his hidden then my row numbers would show 1,2,3,5.