Formula Palette

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
Hi

I have a number of user defined functions registered within my xll. A
Click to expand...
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.
 
Back
Top