View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] -@-ikkevirkelig.com is offline
external usenet poster
 
Posts: 9
Default Need macro to add numbers in rows

Hi,

I hope someone can help.
I need a macro to do the following:

Range A1:A1000
Jump to next row which is not empty
Jump one row backwards
Write the number "1"

Jump to next row which is not empty
Jump one row backwards
Write the number "2"

and so on until selected ranged is completed

Then I need another macro that will be able to find and delete all of the
numbers entered.


Regards,
Kaj Pedersen

---
Denne e-mail er fri for virus og malware fordi avast! Antivirus beskyttelse er aktiveret.
http://www.avast.com