Formula Palette
 

Hi

I have a number of user defined functions registered within my xll. A number of these functions take no arguements but return some information. How can I supress the formula palette when the function returns, I simply want the return value to be inserted into the cell.

Regards
Will

Formula Palette
 

if you are using the formula pallete to insert the function in the cell, you
would have to do it in two steps. Insert the function so it is displaying
the return value, then select the cell, do edit=copy followed by
Edit=PasteSpecial and select values.

--
Regards,
Tom Ogilvy


"Will" wrote in message
...
Hi

I have a number of user defined functions registered within my xll. A
number of these functions take no arguements but return some information.
How can I supress the formula palette when the function returns, I simply
want the return value to be inserted into the cell.

Regards
Will