LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
AEV AEV is offline
external usenet poster
 
Posts: 1
Default Keep data visable in excel from vbscript input

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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup (Source data has a non-visable character) Excel Credit Law Guy Excel Discussion (Misc queries) 3 October 7th 07 03:21 AM
Print Visable Data Only Mitesh Excel Worksheet Functions 1 April 26th 07 03:29 PM
Print Visable Data Only Mitesh New Users to Excel 1 April 26th 07 01:56 PM
Inserting large amounts of data with VBScript... Volker Hetzer Excel Programming 1 August 23rd 05 04:13 PM
Creating properly formatted text file from vbscript using excel data msnews.microsoft.com[_7_] Excel Programming 2 December 18th 03 09:33 PM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"