Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Cell Scroll Bar Problem
I've got the familiar problem of the last cell of data being row 6000, but
the scroll bar going down to 17000. Now, I 've tried the Debra Dalglish method: http://www.contextures.on.ca/xlfaqApp.html#Unused ....and the Dave McRitchie attributed one: Sub makelastcell() ' David McRitchie, posted 2000-11-30 (see lastcell.htm) ' ---- tested only on Excel 2000, should work also on Excel 97 ------ Dim x As Integer On Error GoTo 0 x = MsgBox("Do you want the activecell to become " & _ "the lastcell" & Chr(10) & Chr(10) & _ "Press OK to Eliminate all cells beyond " _ & ActiveCell.Address(0, 0) & Chr(10) & _ "Press CANCEL to leave sheet as it is", _ vbOKCancel + vbCritical + vbDefaultButton2) If x = vbCancel Then Exit Sub Range(ActiveCell.Row + 1 & ":" & 65536).Delete Range(Cells(1, ActiveCell.Column + 1), Cells(65536, 256)).Delete Beep ActiveWorkbook.Save Beep End Sub ......but still no joy. Is there anything else to try (note I've deleted all named ranges)? One point is that the columns carry formating (border and fill) rather than the individual cells. I'm using Excel 2003 by the way. Best regards John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Cell Scroll Bar Problem
Those methods are pretty much it.
You might need to experiment with them (those methods) on new blank sheet, and try to discover what is causing your problem. -- Regards, Tom Ogilvy "John" wrote in message ... I've got the familiar problem of the last cell of data being row 6000, but the scroll bar going down to 17000. Now, I 've tried the Debra Dalglish method: http://www.contextures.on.ca/xlfaqApp.html#Unused ...and the Dave McRitchie attributed one: Sub makelastcell() ' David McRitchie, posted 2000-11-30 (see lastcell.htm) ' ---- tested only on Excel 2000, should work also on Excel 97 ------ Dim x As Integer On Error GoTo 0 x = MsgBox("Do you want the activecell to become " & _ "the lastcell" & Chr(10) & Chr(10) & _ "Press OK to Eliminate all cells beyond " _ & ActiveCell.Address(0, 0) & Chr(10) & _ "Press CANCEL to leave sheet as it is", _ vbOKCancel + vbCritical + vbDefaultButton2) If x = vbCancel Then Exit Sub Range(ActiveCell.Row + 1 & ":" & 65536).Delete Range(Cells(1, ActiveCell.Column + 1), Cells(65536, 256)).Delete Beep ActiveWorkbook.Save Beep End Sub .....but still no joy. Is there anything else to try (note I've deleted all named ranges)? One point is that the columns carry formating (border and fill) rather than the individual cells. I'm using Excel 2003 by the way. Best regards John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll problem | Excel Discussion (Misc queries) | |||
Scroll problem | Setting up and Configuration of Excel | |||
Scroll problem | New Users to Excel | |||
scroll with arrow keys problem | Excel Worksheet Functions | |||
Scroll bar problem | Excel Discussion (Misc queries) |