View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Pickering David Pickering is offline
external usenet poster
 
Posts: 2
Default Formula in dropdown list

Thank you for the prompt reply - but I have tried exactly that (and a bunch
of other things) and it didn't work. That places the formula into the a3 (or
b3 or c3) cell - but as TEXT. It's not active. It's just
'=indirect(etc...). I need something at will let me copy a FORMULA from a
dropdown, not its result - and not its text image.

"CellShocked" wrote:

On Thu, 4 Feb 2010 16:41:01 -0800, David Pickering <David
wrote:
My problem seen above


=TEXT(yourformulahere())