Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I print current row in same place on paper but not print surrounding cells??? Andy Ford New Users to Excel 1 September 2nd 05 05:50 AM
Output Text in specific place narutard[_2_] Excel Programming 3 July 11th 05 09:10 PM
How would I select output to a file or Debug? Toby Erkson[_3_] Excel Programming 2 December 17th 04 01:56 AM
Debug.Print in a WITH procedure? Toby Erkson[_3_] Excel Programming 4 December 15th 04 10:05 PM
Debug.Print ExcelMonkey[_80_] Excel Programming 1 February 6th 04 04:04 PM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"