Thread: covert only cell references in selected cells into value leaving the existingcell formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
al007 al007 is offline
external usenet poster
  
Posts: 118
Default covert only cell references in selected cells into value leaving the existingcell formula
How can I covert only cell references in selected cells into value
leaving the existingcell formula.e.g
If A1=10 & A2=20 D1=30 & D2=40

A3= A1+A2
D3= D1+D2

I would like to have this

A3 = 10+20
D3=30+40

Thxs

Reply With QuoteReply With Quote