I had tried

Public Const MyConst As String
MyConst = "ABCD"

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

Thanks again Tom

--
ob3ron0
-----------------------------------------------------------------------
ob3ron02's Profile: http://www.excelforum.com/member.php...fo&userid=1545
View this thread: http://www.excelforum.com/showthread.php?threadid=27204

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!