View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default converting cell formulaes to code

What do you mean by code?
If you want to convert them to values then
Copy and then Edit|Paste Special|Values

If you want to convert them into the formula, simply replace = with '=. You
can do that by Find/Replace option...

--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"Hein" wrote:

Is there anyway that I can convert formulaes that is currently in cells to
code?

Thanks