Loops and Arrays

I'm none the wiser. Post a sample workbook which illustrates what you want doing.

Hi sorry for not explaining myself properly.

I want to duplicate the text below from 001 to 471.

<image>
<filename>Wedding_Pictures_001.jpg</filename>
<caption>Wedding Pictures 001</caption>
</image>
<image>
<filename>Wedding_Pictures_002.jpg</filename>
<caption>Wedding Pictures 002</caption>
</image>

Down to
<image>
<filename>Wedding_Pictures_471.jpg</filename>
<caption>Wedding Pictures 471</caption>
</image>