What is the actual value/meaning of a semi colon ( ; ) with the Debug.Print
statement in VBA?
I use this often but have no real understanding of it, all I know is that it isn't equal to the vbTab
constant as the spacing isn't the same.
i.e.
Debug.Print 123;456;789
Debug.Print 123 & vbTab & 456 & vbTab & 789
produce different outputs.
It suppresses the generation of a newline character sequence which would otherwise cause a subsequent call to Debug.Print
to output on the next line.
(In your case it's redundant: you'd see an explicit effect if you adjust your first line to Debug.Print 123;456;789;
)
A ;
at the end of a Print statement suppresses the usual default CRLF
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With