How would you get excel to keep the data being written into the
spreadsheet visiable? I have around 400 items and would like the
spreadsheet to scroll along with the data. However once the data that is
being written into the spreadsheet goes over row 33 I can no longer see what
is happing unless I manually pull down the scroll bar. I tried things like
range.select and ActiveWindow.ScrollRow=1 making 1 y= but have had no luck.

Any ideas on what command to look for?

Thanks