Hi all,

i have a spreadsheet with data validion on a cell (a1 on sheet1)
linked to a list on a separate sheet. this list has a few hundred
items.

i need to loop thro the list, calculate and save the workbook as the
cell contents of sheet A1 and continue thro the list.

I know this can be achieved by vba, but it has been sometime since i
delved into writing my own loops in vba. and help would be
appreciated.

thanks