View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default Declaring Variables Public

All constants, whether public or not, are assigned their value in the CONST
statement. See Help.

On Mon, 25 Oct 2004 11:35:03 -0500, ob3ron02
wrote:


I had tried

Public Const MyConst As String
MyConst = "ABCD"

outside of any subroutine, but I didn't think to try it all as one
statement.

Thanks again Tom!