View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
 
Posts: 274
Default For statement behaving very strangely

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