How to create a sequentially numbered URL list

I've been thinking of some way to do this, and it seems Excel is a good choice.

What I want to do is create a list of URLs as below :


www.whatever.com/subfolder/1.pdf
www.whatever.com/subfolder/2.pdf
www.whatever.com/subfolder/3.pdf
www.whatever.com/subfolder/4.pdf
.
.
.
.
.
www.whatever.com/subfolder/17000.pdf
www.whatever.com/subfolder/17001.pdf
www.whatever.com/subfolder/17002.pdf

Can this be done reasonably easily ?
If so, can someone provide a sample spreadsheet or formulae with variable starting and ending points.
eg starts at 1.pdf and ends at 17002.pdf in the above example.

thanks guys !

Yes, sorry for the delay. Been busy in more ways than I can count, and in fact I've only tried the macro a week ago.
The Macro worked well, so thanks !

However, I'm now trying to do it again, but it seems that after the latest batch of Windows updates, that Excel 2007 no longer likes the macro as I get a compile error when I run it.

Any ideas why ?

Anyone got a fix for the compile error in Excel 2007?

This VBa seems to work reasonably fast, might be worth a try, it should be faster than using a loop

Please Login or Register  to view this content.

To make it more flexible this might be better
You can chose the range to fill and the number to start with.

Please Login or Register  to view this content.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.