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

How can read my Global Const statements, use the name value and create a
defined name as in Insert|Name|Define

Global Const XXX = 21

In the name box I want "XXX", in the Refers to box I want =21.

All this VBA code.

Thanks