Enter this formula in A1 then copy down through A10 (or however far you need).

=SUBTOTAL(103,$B$1:B1)

For this to work, column B must contain data in every cell. If column B
contains blanks, then use a different column. If you don't have a column
that has data in every cell, then create one, fill is with junk data, then
hide it.

HTH,
Elkar


"TY" wrote:

If I have listed in column A 1 through 10 with A-1 containing the number 1
and A-2 containing the number 2 and so on through A-10. If I hide a row, I
want the numbers to auto populate so I have the numbers 1-9 in column A.
Can anyone tell me how to do this?