Please see the sample file. The sample file only contains sample data with 3 rows of input, the macro should run until all rows in column A to D are processed.
Column A is not used in the macro, but is for naming only.
Column B contains a URL
Column C & D contains the starting and ending number to be appended to the URL in Column B. Each number is to be appended in sequence until the ending number is met.
The output of all URL's is to be put in column F.