ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Defined Names revisited (https://www.excelbanter.com/excel-programming/311879-defined-names-revisited.html)

Sheldon

Defined Names revisited
 
I have set up MANY global constants as follows

Global Const ROW_A = 7
Global Const ROW_CDE = 14
Global Const ROW_BQL = 21
etc

How do I read the names of these constants and the values, in code, to create
Insert | Name | Define | In the 'name box' I would place the names of the
constants, and in the 'Refers to box' I would place the value.

Thanks


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com