how can i get VBA to give rows numbers
 

I have made a formular to fill in data in a sheet, but i can't figur out how
to make the formular give the rows increasing numbers.....
I bet it's pretty simple, but I just can't get i right.

thanks

how can i get VBA to give rows numbers
 

Just use the ROW() function.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Bahnando" wrote in message
...
I have made a formular to fill in data in a sheet, but i can't figur out
how
to make the formular give the rows increasing numbers.....
I bet it's pretty simple, but I just can't get i right.

thanks

how can i get VBA to give rows numbers
 

ActiveCell.Row


"Bahnando" wrote in message
...
I have made a formular to fill in data in a sheet, but i can't figur out
how
to make the formular give the rows increasing numbers.....
I bet it's pretty simple, but I just can't get i right.

thanks