macro to fill out a column with continuos numbers

**lab** · 06-16-2009, 06:40 AM

hey friends,

i want to fill out my first column with continuos numbers. in the second column are data. now i want to count the amount of data in the second column and write the number of the corresponding row in the first column. is there anywhere an easy command or do i have to use a macro. if i have to use a macro how do i have to build it. i don't have many experience with vba

greetings

**pike** · 06-16-2009, 07:46 AM

HI lab
in a1 put

=IF(ISBLANK(B1),"",ROW(B1))

and fill down

**lab** · 06-16-2009, 09:52 AM

thank you,

that was very helpful. i had to translate in spanish so if anybody needs this command in spanish, here it is:

=SI(CONTAR.BLANCO(B1);"";FILA(B1))

greetings