View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
aflatoon[_21_] aflatoon[_21_] is offline
external usenet poster
 
Posts: 1
Default For statement behaving very strangely


It's 200 actually. You will see 199, then you have one blank row left
at the bottom for entry.


michael.beckinsale;731158 Wrote:

Hi All,

Sorry if anybody has spent any time on this.

The code is fine. However l have learnt that the immediate window only
appears to be restricted to 198 rows. So if you Debug.Print i for 1 to
1200 only the last 198 appear in the immediate window (eg 1003 to
1200)

It would be great if somebody could confirm that l am correct on this.

Regards

Michael



--
aflatoon

Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile: http://www.thecodecage.com/forumz/member.php?u=1501
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=204918

http://www.thecodecage.com/forumz