Help with VBE Need to autoselect rows

  • Thread starter Thread starter greenfalcon
  • Start date Start date
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
 
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 **
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with VBE Need to autoselect rows 1
Sort by Every Other Row? 0
Formula from consecutive rows to alternate rows? 2
Excel Help to copy information from one row at a time to another sheet 1
Count help with numbering Rows? 2
Need fast help in excel counting 4
Conditional Formatting and Autofilter 4
Help Reg Print 1

Back
Top