View Single Post
  #2   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

Pick up only the formulas

select the range to copy, then do Edit=Goto =Special and select formulas

then do your copy.

--
Regards,
Tom Ogilvy


"Brett" wrote in message
...
How can you copy a range and then paste cell contents only if the cell
contents is a formula (cell contents begins with "=")?