aueddonline
09-07-2011, 01:51 AM
I am trying to debug a macro. It's failing on the lien below 'If (CDate(ar(4)) <> dat$) Or (ar(1) <> cln$) Then'.
I wanted to check the values in the variables/arrays, how can I view these?
If (CDate(ar(4)) <> dat$) Or (ar(1) <> cln$) Then
Print #2, ar(1), CDate(ar(4)) ' log list of dates
dat$ = CDate(ar(4))
cln$ = ar(1)
End If
I wanted to check the values in the variables/arrays, how can I view these?
If (CDate(ar(4)) <> dat$) Or (ar(1) <> cln$) Then
Print #2, ar(1), CDate(ar(4)) ' log list of dates
dat$ = CDate(ar(4))
cln$ = ar(1)
End If