Thank you for your help. However I have still two problems.
First, The sheet that I'd like to return belongs to a workbook that I get
with the function GetObject(). With this function, it appears that the
corresponding workbook stay open, but doesn't have exactly the behavior of
an open workbook. I think that I'll drop it (using GetObject) in favour of
the Open() method.
Secondly, I just realized it in running the exemple; I made a small
subroutines to delete the new sheet just added. Each time I execute the
Delete method in this routine, I got a message to confirm. My question: is
it possible to bypass this message and have the order excuted silently?
Thanks again.
Jean-Pierre

"Jean-Pierre Bidon" a écrit dans le message de news:
...
Hi,
My problem is rather basic but I am stumped.
Here it is: is it possible to return a worksheet object from a user
defined function (possibly via a ByRef argument)?
I'd appreciate an exemple of syntax in order to try it.
Many thanks in advance.
--
Jean-Pierre Bidon
Interstat
91 rue de Rennes
75006 Paris
Tél: 01 45 49 19 17