Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll to last row with Data
Hi,
Is there a way to scroll down to the last row that contains data? I'm using the "LASTINCOLUMN" Function right now to get a value, but would also at times like to go physically to the last row too. I would run this procedure by pushing a command button. I understand how to connect the button to the procedure. I tried the archives but maybe didn't word it right. Thank you for your time, Amy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll to last row with Data
I use this to goto the last row then scroll up so the last row is near
the bottom. Application.Goto reference:=Cells _ (ActiveCell.SpecialCells(xlCellTypeLastCell).Row, 1), _ Scroll:=True ActiveWindow.SmallScroll Up:=40 'Change 40 as needed Charles AMY Z. wrote: Hi, Is there a way to scroll down to the last row that contains data? I'm using the "LASTINCOLUMN" Function right now to get a value, but would also at times like to go physically to the last row too. I would run this procedure by pushing a command button. I understand how to connect the button to the procedure. I tried the archives but maybe didn't word it right. Thank you for your time, Amy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll to last row with Data
Thanks Die, it works!
The "ActiveWindow.SmallScroll Up:=40 'Change 40 as needed" feature is a nice touch too. Amy "Die_Another_Day" wrote: I use this to goto the last row then scroll up so the last row is near the bottom. Application.Goto reference:=Cells _ (ActiveCell.SpecialCells(xlCellTypeLastCell).Row, 1), _ Scroll:=True ActiveWindow.SmallScroll Up:=40 'Change 40 as needed Charles AMY Z. wrote: Hi, Is there a way to scroll down to the last row that contains data? I'm using the "LASTINCOLUMN" Function right now to get a value, but would also at times like to go physically to the last row too. I would run this procedure by pushing a command button. I understand how to connect the button to the procedure. I tried the archives but maybe didn't word it right. Thank you for your time, Amy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How the data may stay on top with scroll ? | Excel Worksheet Functions | |||
Scroll data into 3 columns | Excel Discussion (Misc queries) | |||
how do i create a scroll bar for my data? | Excel Discussion (Misc queries) | |||
Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
How to scroll data in a chart? | Excel Programming |