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