I declared the following variable for use in some procedures concerning
Public cellLimit As String
In the AutoOpen procedure cellLimit is initialized:
cellLimit = vbCr + Chr(7)
Nevertheless in some cases - not reproducible so far - obviously cellLimit
looses its value and becomes "",
but is no other statement in my modules where the value of cellLimit ist
What may be the reason for this strange behaviour?
How could the problem be resolved?
I would like to have 'cellLimit = vbCr + Chr(7)' as constant, but
unfortunately this isn't possible in VBA.
Is there perhapse another way to get 'vbCr + Chr(7)' as public constant?
Make your own search :
Copyright © 2001-2013 GNT Media