View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Halim Halim is offline
external usenet poster
 
Posts: 182
Default veriable to constant

Did you have this:

Const Ten as integer = 10

so use Ten for getting 10
--
Regards,

Halim



"Hassan" wrote:

Hi All,

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.

Thanks & Regards

Hassan