with computers of now a days, scrolling may be useless, but just a wish
i am listing a selective data(1000 rows) from mass data 40000 rows,
inventory sheet.
the listing takes hardly 30-45 secs maximum
does VB write row by row and cell by cell or it writes like snap in one shot
of all 1000 rows, keeping everything in memory

if it writes, i wish it can scroll while writing in the excel sheet.
any code to do that scrolling while writing.