Help with VBE Need to autoselect rows

G

greenfalcon

Ok that works, but now i have one last problem

when i run that command i have rows with row numbers in them fo
example

1
2
3
4
and so on. the code i currently have in these cells is =row(a1)
=row(a2) and so on.

my problem is when i use this code it puts in 2 rows and my rows no
look like

1
2
1
2
3
4

is their any way to make the numbering automatic?

Thank
 
P

Paul B

greenfalcon, try just =ROW()
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
Top