View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phillips[_3_] Phillips[_3_] is offline
external usenet poster
 
Posts: 9
Default How can I copy the FORMULA in a cell to a different cell?

I would like to copy the formula from 1 cell to a different cell. I want to
do this ONLY if there is a formula.

For instance, I might have a formula in column D and F on worksheet "Test"
in each row

I would like to, on worksheet "Test2" to copy the actual formula into a give
cell. How can I TEST for the presence of a formula, and then how can I copy
the actual "=function()" to my new cell (preferably with a delimiter infront
so I can actually see the formula.

Thanks