Number of lines in the Immediate Window
in [Programming]
|
From: Peter T on 20 May 2010 06:05 I only get 199! Other ways to preserve all the debug info might be to write to cells in a temporary sheet or to a log file. Regards, Peter T "Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote in message news:uZ7EJr89KHA.420(a)TK2MSFTNGP02.phx.gbl... > Like Gary, I also get 200 displayed lines in the Immediate Window. To the > best of my knowledge, that number is fixed by design. You can get more > information into the Immediate Window by ending **each** of the "print to > the Immediate Window" statements with a comma... that way each item will > print one tab field away from the previous value. This is not as > convenient to read back, but it does allow you to review a tremendous more > amount of information before having the initial values scrolled off the > screen. > > -- > Rick (MVP - Excel) > > > > "Mike" <mikea365h(a)hotmail.com> wrote in message > news:yLednW-eXvTZB2nWnZ2dnUVZ_h6dnZ2d(a)pghconnect.com... >> Thanks Dave. I realize that you can use the scroll bars but there is a >> limit to the number of lines that will scroll. It appears that the limit >> is approximately 100 lines. >> >> >> "ozgrid.com" <dave(a)ozgrid.com> wrote in message >> news:uoaYM079KHA.420(a)TK2MSFTNGP02.phx.gbl... >>> Drag it up/down so the displayed lines increases. >>> >>> >>> >>> -- >>> Regards >>> Dave Hawley >>> www.ozgrid.com >>> "Mike" <mikea365h(a)hotmail.com> wrote in message >>> news:LtadndPqnc_wDGnWnZ2dnUVZ_qWdnZ2d(a)pghconnect.com... >>>> Is there any way to increase the number of lines that can be displayed >>>> in the Immediate Window? >>>> >>>> Thanks >>>> >>> >> >> |