Number of lines in the Immediate Window
in [Programming]
|
From: Mike on 19 May 2010 21:33 Is there any way to increase the number of lines that can be displayed in the Immediate Window? Thanks
From: ozgrid.com on 19 May 2010 21:37 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 >
From: Mike on 19 May 2010 22:11 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 >> >
From: Gary Keramidas on 19 May 2010 22:26 i get about 200. -- Gary Keramidas Excel 2003 "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 >>> >> > >
From: Rick Rothstein on 19 May 2010 23:15
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 >>> >> > > |