View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default veriable to constant

How its possible to change veriable values to constant values,
e.g. if I count "Excess" and the formula returns 10 and after deleting
"Excess" from the row then formula returns 0, I want that 10 become
constant.


Select the cell, then click Edit/Copy (or key in Ctrl+C), leave the same
cell selected and click Edit/Paste Special, select Values from the Paste
area (leave None for the operation) and click OK. Finally, key in Esc to
remove the selection.

Rick