Excel macro help

[bongoman]

Hi WD,

I need help creating a macro for excel which will count per row the numbers between two ranges.
eg range 1000-1200
1000
1001
1002
...1200
I have never created a macro before so details are appreciated. Thanks

[Lowland]

Hi bongoman...

Macros come into their own for automating repetetive tasks. The easy way to create them is to use the macro recorder function. Choose a name for your macro, click the record button, then everything you do on your workbook is recorded and can be played back whenever.

However macros come with a unique set of problems. not least that they have been used many times as a transport for viruses, malware and so on, and they can be exremely inefficient when the macro recorder is used as it captures all screen activity and not just the code you want to use.

Maybe someone can give you some concrete hints, but personally I would recommend you Google a bit for tutorials (like this one) http://www.tutorialized.com/view/tut...Tutorial/10181

Good luck with your learning