Public variable looses value

[Thomas Wiedmann]

Hello,

I declared the following variable for use in some procedures concerning
table cells:
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
changed.

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?

Thomas Wiedmann

 

[Harold Druss]

Hello,

I declared the following variable for use in some procedures concerning
table cells:
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
changed.

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?

Thomas Wiedmann

Hi Thomas
Try using "vbCr & Chr(7)"
Harold

 

[Thomas Wiedmann]

Try using "vbCr & Chr(7)"

ah - of course - thanks.

Thomas Wiedmann