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
|