Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value translation
Hi Sheldon,
You cannot use a VBA constant in your worksheet. Instead, try using a defined name: Insert | Name | Define | In the names box type RowX | In the Refers to box type =21 | OK Now, typing ROWX - 1 in the cell will return 20. --- Regards, Norman "Sheldon" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Language Translation | Excel Discussion (Misc queries) | |||
Code translation please | Excel Discussion (Misc queries) | |||
Translation/formula. | Excel Discussion (Misc queries) | |||
RNG translation | Excel Programming | |||
Need Translation | Excel Programming |