Scroll Down/Across Worksheet Doesn't Move
Aug 10, 2006
I have two basic questions regarding the Excel program/UI
I'm currently using Excel 2000, One annoying thing I find with this version is the way the screen doesn't follow along with my scrolling. ie: when I use the vertical scroll bar on the main window, it only updates once I release... not like a typical window which follows the movements of the scroll curser. Is this typical for later versions?
I would update this program just for this feature alone!
Also, a final question.... Does anyone know if there are any plans to update the handheld (pocket pc) version of Excel? The factory installed program is incredibly limited.
View 6 Replies
ADVERTISEMENT
Feb 8, 2012
I'm using Excel 2007. When I try to scroll with the mouse wheel, it doesn't do anything. If I hold down the control key and scroll with the mouse, it zooms in and out. So that works fine, but I can't do the basic scrolling up and down the document with the mouse wheel. There is no "Tools, Options" menu in 2007 so I don't even know where to find this type of option. The options available from the Office button are completely different.
View 4 Replies
View Related
Aug 20, 2008
i've a little problem @ work. Each morning i've to insert some data of the day before and update 2 chart with some series moving the seriescollection frome 5 days before to the data that i've inserted in that moment. I'm trying to do a macro that do automatically that "seriescollection shift" to avoid to do that manually for each seriescollection of each chart each morning. I mean (maybe i've been not very clear) i usually click on the chart series, then i can see the range data source and using the mouse i move this range 1 column in plus on the right mantaining width.
View 3 Replies
View Related
Jan 13, 2007
In the menu via TOOLS-->OPTIONS-->VIEW I am trying to remove the scroll bars from just one worksheet but when unticked, this option affects all of the worksheets in my workbook. Is there a way to just nail this selection down to one sheet via properties?
View 2 Replies
View Related
May 18, 2011
I have a datatable with data from 2010 and 2011. The worksheet will not scroll at all. It looks like it is scrolling at the side where the scroll bar is but the worksheet does not move. I can move the tab up or down but the page/worksheet doesn't move at all. If I activate the filter and select only the year 2011 in the drop down box for the Date column, it scrolls fine. But if I check "All Dates" or just "2010" from the drop down box on the Date column the page/worksheet will not scroll. I can select a certain month from the drop down box for 2010 and it will show the data (about 25 rows) but I cannot scroll. When I have just 2011 selected from the filter it all works fine. I'm not real swift with Excel. It was working fine until today.
View 3 Replies
View Related
Feb 22, 2012
I'm using the following code. It works fine when it comes to selecting the cell. However, I'm not sure how to bring the view of the worksheet such that the selected cell is in the middle of the sheet. I've the data horizontally laid out from column A to column BM. So, when someone makes a change in Sheet2 I need to point to the corresponding column in Sheet1 such that it is in the view.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim CellName As String
CellName = Range("A1").Value
[Code]....
View 1 Replies
View Related
Oct 22, 2008
I have a workbook with 8 sheets, one of which is the "main" sheet that holds all of my user data for logins at my job (I'm in IT). There are about 4300 users and 23 fields for each user, so there are 4300 rows in the sheet. Other sheets in the book are important, but not as much as this one.
The workbook has a total of over 1000 lines of VBA code right now, as I'm building a tool that finds users, adds users, modifies users, etc. (I know, Access would be smarter for this, but for some reason they want me to use an xls). Most of this code works with the sheet that I'm having the problem on.
This ONE sheet has seemed to disable the functionality of the scroll wheel, and I can't use Page Up or Page Down while in the sheet either. Also, if I select cells with VBA (Sheet2.Range(<range>).Select), it will select the cell, but it will not draw focus to that cell on screen (the sheet will not move at all). The other 7 sheets in the workbook have all regular functionality.
This just started happening a couple days ago, and I've been building the code for about a week, so I'm wondering if it's something in the code...?
Does anyone have any idea what might cause this?
View 14 Replies
View Related
Sep 2, 2006
I used to have cells in the extremes of my worksheet filled which resulted in the scroll bars being stretched very thin. Since then, I am only using the top-left part of the worksheet but it is difficult to scroll through since the scroll bars are still stretched. How do I bring them back to normal?
View 5 Replies
View Related
Aug 21, 2008
I am having problems with an Excel workbook I am working on. I have a sheet that has a number of controls added to the top of it. Two of these controls are listboxes. My problem is, if I am in the listbox navigating through it, and I accidently move the Mouse Wheel, Excel crashes and I get the usual, "Send Error Report" form.
I have seen that there are other people having this problem and that there are a number of solutions out there but my problem is a bit different. I have a few forms with listboxes on them, and while mouse wheel scrolling doesn't work, it certainly doesn't crash Excel. It only seems to happen when I have a control permanently added to the sheet. Is there any event handler for mouse wheel scrolls or anyway to disable them through VB?
View 2 Replies
View Related
May 22, 2008
I need to create a worksheet and then populate it with header row containing columns names, and with values starting at row2. Before I do all this I wanted to first create a spreadsheet, I was successful in getting this done by getting a piece of code from this website. But, what if spreadsheet already exists from a previous run, then, in that case I want to clear the contents. Before I get too far ahead, I am unable to escape runtime error 9, array subscript out of range whenever I use any sort of code to check if the sheet exists.
Also, my attempts to circumvent this error by putting in errorhandling is ignored, i.e. I get the standard run-time error message box, but, not what I want the code to do is such an error occurs.
Function wsExists(wksName As String) As Boolean
On Error Resume Next
wsExists = CBool(Len(Worksheets(wksName).Name) > 0)End Function
Private Sub Cmbsummary_Click()
On Error Goto ErrHandler:
'Worksheets("MySheet").Activate
Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = "MySheet"
Exit Sub
View 4 Replies
View Related
Apr 13, 2009
look for a certain value in worksheet A and copy that row of data to Worksheet B.
However, it seems to be only copying the row in worksheet A and pasting it. Is there something that a noob VBA scripter has missed out?
PHP Private Sub GetInfo_Click()
Dim r As Long, LastRow As Long, Status As Integer
Dim Message As String, Title As String, Default As String, MyValue As String
Application.ScreenUpdating = False
MyValue = Range("A4").Value
Workbooks("invoice.xls").Worksheets("A").Activate
LastRow = Range("C65536").End(xlUp).Row
For r = LastRow To 1 Step -1
If Cells(r, 1).Value = MyValue Then
Rows(r).EntireRow.Copy
Workbooks("invoice.xls").Worksheets("B").Activate
Rows("8").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Status = 1
Workbooks("invoice.xls").Worksheets("A").Activate
Rows(r).EntireRow.Delete
Exit For
End If
Next r
Application.ScreenUpdating = True
View 2 Replies
View Related
Mar 18, 2014
I have a macro below where it looks at sheets name and deletes if Jan is not there.
I would like to change this a bit so that it looks for all 12 months (Jan to Dec) instead of looking for Jan only.
View 8 Replies
View Related
Mar 10, 2012
I'm not sure why this macro in workbook "A" is not working when checking for the activesheet sheet opened in workbook "B"? I've included the tab name I'm looking for and the tab name opened in the workbook "B" in the MsgBox to verify it can pull the tab names properly in workbook "B" and it returns correctly. I'm not sure why the If Then Else is not working if that is the issue here.
Code:
Sub testmonthcheck()
Dim art156 As Workbook
Dim mm As String
Dim mmm As String
Set art156 = Workbooks("Actual_Run_Times_156.xls")
[Code] ........
View 1 Replies
View Related
Apr 2, 2007
I have a combo box in a worksheet with a macro written for it that works fine but when I open the worksheet it doesn't run automatically, I have to find the macro and tell it to run.
How can I get it to run as soon as the worksheet is opened
Here is the code for the macro
Private Sub combobox()
ComboBox1.clear
ComboBox1.AddItem "Mit Rekuperator"
ComboBox1.AddItem "Ohne Rekuperator"
End Sub
Private Sub ComboBox1_Change()
Run "PinchInternHeatExchanger"
Select Case ComboBox1.Text
Case "Mit Rekuperator"
ActiveSheet.Range("I62") = Worksheets("uorc").Range("L99")
Case "Ohne Rekuperator"
ActiveSheet.Range("I62") = Worksheets("uorc").Range("E11")
End Select
Run "PinchPoint"
End Sub
View 9 Replies
View Related
Jun 4, 2007
I'm trying to simplify a formula that I'm using in a spreadsheet that's being used mostly in Excel 2000.
2 reasons I'm doing this:
1) It doesn't work if the worksheet hasn't been saved yet.
2) It's ugly
=DATE(YEAR(DATEVALUE(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,3) & " 20" & MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+5,2))),MONTH(DATEVALUE(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,3) & " 20" & MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+5,2)))+1,0)
The formula returns the last day of the month of the name of the sheet. For example, if the sheet is names "Mar 07", it returns 3/31/07. (yeah, when the 2100 issue becomes a big deal, I'm not going to be ready but I have 92 years to think about it)
Even if I can't make it prettier, does anyone have a way to get the sheet name into a formula without VBA Code in a file that hasn't been saved.
View 9 Replies
View Related
Sep 11, 2006
I have a column containing 365 entries, one for each day of the year. This I intend to send out to Army bands, to have them fill in their forecast of engagements. I do not want them to be able to amend the original diary, but to scroll to the bottom of the list, add a new entry with the applicable date and then be able to 'sort' back to chronological order. This would then allow a separate entry for every engagement to allow me to interrogate the spreadsheet. As I have protected the sheet, the 'sort' facility does not function even though when protecting I ticked the box to allow users to 'sort'.
View 2 Replies
View Related
Mar 5, 2008
I have a workbook, with an around 70 sheet. Every sheet presents a sample reprot supplied by my client, the 3rd row in every sheet holds the report's title, (actually, not the whole 3rd row is merged, only specific range of cells are merged and this range is different among the sheets, e.g.: In the first sheet, the cells B3:M3 are merged to hold the title where in the second sheet , the cells B3:N3 are merged)
Now i need to copy all these titles to a separate sheet,
if I have to un- merge the cells or re-merge the whole row, I will not mind, espically if I will get a quiker solution since i also have another 3 similar workbooks.
View 5 Replies
View Related
Mar 28, 2009
I have written a user-defined function that searches for a small range within a larger range. The function requires two input parameters: the range you are looking for, and the range you want to look within.
For example, I might look for the string of values in cells A1:D1 in a larger range E1:H20. The function returns the row number in the larger range where the smaller range is found.
My problem is this: The function is working fine when I call it from another sub procedure. However, when I try to run it as a worksheet function, I get a "#VALUE!" error. The function pops up in the "insert function" menu, and it prompts for the two input parameters.
View 6 Replies
View Related
Nov 26, 2007
I am using the toolbox/ properties method to restrict the scroll area in the sheets of my workbook. However, for some sheets when i keep the right hand arrow pressed, the screen will not scroll to the last column. (i.e. the screen display will not move with the selected cell box)
View 2 Replies
View Related
Feb 21, 2014
I have this formula =COUNTA($A:$A)<=4 that limits amount of cells that can be populated in column A, I use data validation with "Allow costume" option and using that formula. It works fine from worksheet it displays the message when the limit is reached but it doesn't work when data is inputed/populated from userfrom, it allows userform to put more entries than set limit 4 in this case.
View 3 Replies
View Related
Dec 31, 2008
I have a bit of code that calls a formatting sub depending on which cell is modified. It is triggered by the Worksheet_Change event, determines which cell is modified, and either calls the formatting sub or doesn't based on the location of the modified cell.
Some of the columns in the sheet have data validation with drop downs. If I select a value from the drop down, it doesn't trigger the Worksheet_Change. If I type a value into the same cell, it does.
This was apparently an issue in Excel '97, but supposedly fixed in '03?
View 9 Replies
View Related
Aug 19, 2013
I'm trying to make a range selection in a pivot table as per the snapshot below:
http:[url],....
The values I am trying to select are the ones that are both red and italic. (Mobile, Other Fix, Fix) from CBU_NA.
I've searched and found a way to select both the rows for CBU_NA category and also the column categ2.
However when I try to make an intersection out of the 2 ranges I receive an error. I'm using Excel 2010 on windows 7.Below the code I am using:
Code:
Sub FCST()
Dim r1, r2, r3 As Range
r1 = pt.PivotFields("categ2").DataRange.Select
Selection.Font.Italic = True[code]...
View 2 Replies
View Related
Jan 15, 2010
I have a Excel workbook with two sheets - 'MainDataSheet' and 'ArchiveSheet' .
The 'MainDataSheet' has 5 columns and one of the column is 'status'.
The 'MainDataSheet' will have a command button 'MoveData' which will trigger the VBA macro to move data rows from 'MainDataSheet' to 'ArchiveSheet' . Only the rows having value set to "MOVE" in the 'status' column have to be moved.
View 9 Replies
View Related
Oct 24, 2011
Code below. I need it to NOT run if the sheet week2 doesn't exist. Currently it gives a runtime error '9' out of range. This is due tot he sheet not being present because sometimes it is not generated.
Code:
Sub RemoveColWeek2sheet()
Dim ColNo As Integer
Dim rng As Range
Set rng = ThisWorkbook.Sheets("Week2").UsedRange
[Code] .........
View 6 Replies
View Related
Mar 25, 2007
I've written a program that list all the occurences of a given name in a specific cell from all worksheets in the active workbook. The list is placed in a listbox and the first listing is selected with ListBox1.Selected(0) = True. Additionally the worksheet of the first listing is activated.
My question is now how do I either scroll through each name in the list box and activate the "current" worksheet. I assume that I'll need to address scrolling up/dowm and clicking of any particular name on the list.
View 9 Replies
View Related
Apr 16, 2014
Move a row of work to resolved tab once column M is changed to resolved This needs to be moved to the first available line on the resolve tab The row that has just been moved from the orginating agents tab needs to be deleted and shifted up When moved to the resolved tab I want it to prepopulate where the row originated from in column N When moved to resolved tab I want it to prepopulate the date it was resolved Also the spreadsheet will be shared
I have attached a test version of the spreadsheet.
View 2 Replies
View Related
Aug 26, 2008
I have whats going to be a very large "Input" worksheet that has several headings of columns. One of these columns is "category" as in parts of a vehicle, i.e. steering, wheels, rod-ends and so on. Now what I would like to do, is once I type a new row of information in, to have the filter go through and copy said category row into another worksheet where I can have all of them separated on there own.
Here is a picture of my current spreadsheet. So basically I want to be able once I save the file, that it goes through and where it detects Rear-End in "B18" I would like it to select row 18, copy all of its cells and move them into the worksheet Rear-End
View 14 Replies
View Related
Mar 28, 2014
I created a outstanding task worksheet in excel and I would like to move the completed jobs from this sheet to the second worksheet titled 'Completed Tasks'. The first worksheet is called 'Outstanding Tasks'.
I came up with a code to do this (see below). As you can see when I type "Y" into column G it moves the row into the second worksheet. It does this; however it puts it to the bottom of the table on the second worksheet where I would like it to be at the top. I also would like it to delete the row once it has moved it does this but then deletes the other row of information above it leaving blank rows on either side.
I simply want a code that moves the row of information to the second worksheet when I type Y into column G and then delete the row without messing with other information around it.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim rng As Range
Set rng = Target.Parent.Range("G5:G1000")
If Target.Count > 1 Then Exit Sub
If Intersect(Target, rng) Is Nothing Then Exit Sub
Select Case Target.Text
Case "Y"
Target.EntireRow.Cut Sheets("Completed Tasks").Cells(Rows.Count, "A").End(xlUp).Offset(1)
Selection.ListObject.ListRows(1).Delete
End Select
End Sub
View 1 Replies
View Related
Sep 16, 2008
I have a workbook with two worksheets in it. The first "TO DO" and the second "Completed". In "TO DO", I have rows of tasks starting in row 4 (row 3 is my header), going to 200. What I'd like to have happen is when I put a "C" in column C, it moves the entire row to the "Completed" worksheet, greys it out and removes it from the "TO DO" worksheet. Then if I remove the "C" from the "Completed" worksheet, it moves it back to the bottom of the list. I already have a macro to resort it based on "priority" in column E.
View 9 Replies
View Related
Nov 2, 2008
i need to get certain info from one worksheet to another is there any way to do this automatically
View 9 Replies
View Related
