Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make the last rows visible?
Hello,
I am using Excel automation and vbasic 5 programming to add data to the opened sheet, however after reaching the sheet's window full of data the next rows of data are below the screen. How to display the current row and preferrably a few empty rows after that in real time? Please advise, Fred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make the last rows visible?
This will scroll down five rows on the active sheet.
Sub fj() ActiveWindow.SmallScroll Down:=5 End Sub You should be able to manually scroll. However, if you need to use code the above scrolls by line. Use the same syntax with LargeScroll to scroll by page. Direction options are Up:=, Down:=, Right:= and Left:= "fred" wrote: Hello, I am using Excel automation and vbasic 5 programming to add data to the opened sheet, however after reaching the sheet's window full of data the next rows of data are below the screen. How to display the current row and preferrably a few empty rows after that in real time? Please advise, Fred |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make the last rows visible?
You can set the row number of the top visible row for the active sheet using
this... ActiveWindow.Panes(ActiveWindow.Panes.Count).Scrol lRow = RowNumber where RowNumber is the number of the row that you want displayed at the top of the active worksheet. If you want to show some of the filled rows above that row, you can subtract that number for RowNumber (but you will need to protect against the value going negative. Something like this... If RowNumber 15 Then ActiveWindow.Panes(ActiveWindow.Panes.Count).Scrol lRow = RowNumber - 15 End If -- Rick (MVP - Excel) "fred" wrote in message ... Hello, I am using Excel automation and vbasic 5 programming to add data to the opened sheet, however after reaching the sheet's window full of data the next rows of data are below the screen. How to display the current row and preferrably a few empty rows after that in real time? Please advise, Fred |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make the last rows visible?
Thank you. That is a good start.
But, how to detect that the row is already off screen? I do not want to do scroll anything until the page is filled. Thanks, Fred "JLGWhiz" wrote in message ... This will scroll down five rows on the active sheet. Sub fj() ActiveWindow.SmallScroll Down:=5 End Sub You should be able to manually scroll. However, if you need to use code the above scrolls by line. Use the same syntax with LargeScroll to scroll by page. Direction options are Up:=, Down:=, Right:= and Left:= "fred" wrote: Hello, I am using Excel automation and vbasic 5 programming to add data to the opened sheet, however after reaching the sheet's window full of data the next rows of data are below the screen. How to display the current row and preferrably a few empty rows after that in real time? Please advise, Fred |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make the last rows visible?
Thank you, Rick.
That's exactly is what I was looking for. Fred "Rick Rothstein" wrote in message ... You can set the row number of the top visible row for the active sheet using this... ActiveWindow.Panes(ActiveWindow.Panes.Count).Scrol lRow = RowNumber where RowNumber is the number of the row that you want displayed at the top of the active worksheet. If you want to show some of the filled rows above that row, you can subtract that number for RowNumber (but you will need to protect against the value going negative. Something like this... If RowNumber 15 Then ActiveWindow.Panes(ActiveWindow.Panes.Count).Scrol lRow = RowNumber - 15 End If -- Rick (MVP - Excel) "fred" wrote in message ... Hello, I am using Excel automation and vbasic 5 programming to add data to the opened sheet, however after reaching the sheet's window full of data the next rows of data are below the screen. How to display the current row and preferrably a few empty rows after that in real time? Please advise, Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a txtbox not visible | Excel Programming | |||
How to make a few rows visible and hide some others ... faster | Excel Programming | |||
VBA Help with Make Visible Rows | Excel Programming | |||
Fast way to make rows visible and invisible | Excel Programming | |||
I need to make MS word visible..please help | Excel Programming |