ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   place output of several debug.print statements on the same line (https://www.excelbanter.com/excel-programming/338199-place-output-several-debug-print-statements-same-line.html)

[email protected]

place output of several debug.print statements on the same line
 
The code

debug.print x
debug.print y

will print x and y on separate lines in the Immediate window. How can I
tell debug.print not to skip to the next line? Thanks.


[email protected]

place output of several debug.print statements on the same line
 
Either use Debug.Print "value one" & " " & "value two" or put a
semicolon at the end of each line.
Debug.Print "value one";
Debug.Print "value two";
Debug.Print "value three"

The second method allows your Debug.Print statements to fall any place
within the code. The first requires you know everything you want to
Debug.Print up front.



All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com