If you record a macro when you do it manually (once), you'll see the basic code.

If you need help modifying it, post back with the code you recorded.

Sam wrote:

thx
actually i've managed to do that
but how do i do it programmatically, that is in a macro ?
How do I refresh the sheet ?

tx

--

Dave Peterson