View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sheldon Sheldon is offline
external usenet poster
 
Posts: 51
Default Value translation

I have set up global constant as follows

Global Const ROW_X = 21


On one of my worksheets I have placed "ROW_X - 1" in a cell.

When I read the value in the cell I get "ROW_X - 1". I need to get this
translated into 21 - 1 which would equal 20.

How can I do this?

Thanks