Quote Originally Posted by paul
...you cannot have an input and an out put in the same call in excel.The input would overwrite the cell contents
Thanks for the replies. That was what I was experiencing and was affraid I was asking too much of it. I've seen it done in VB and kinda thought Excel might be able to handle it too.
I was hoping to have it all contained in the one table but it appears I'll have to create another as suggested.

Cheers
Pete