scroll down worksheet

  1. R

    Macro - Excel won't scroll down to highlighted cell

    Hi Guys - I wrote a Macro that will highlight a cell when the contents of the cell matches the searching criteria. The macro works fine, except that if the cell being searched is in row 200, Excel won't scroll down to where the cell is. For example. I have a spreadsheet that contains 290 rows...
  2. J

    Alternatives for INDIRECT in cascading (dependent) dropdown lists causing slowdown and headaches

    Hi, Calling all Excel geniuses, I’m working on a project for a friend, I’m already way beyond my comfort zone in Excel, and am have an issue that I can’t get around. My project involves making a sheet that acts like a form with each row being a series of dropdown menu’s (to limit the users...
  3. E

    VBA worksheet change to scroll down to specific text

    Hi All I'm reasonalby fluent in excel but my vba knowledge is limited. I'm looking for some help with a code to scroll down to a specific title when a selection is made from a drop down list at the top of the page? looking to save a lot of scrolling and ctrl F time please help Cheers!
  4. H

    Hyperlink with Vlookup

    Hi, I am having some trouble with setting up a hyperlink with a Vlookup. I want to set up a Hyperlink, returning the description of the code as well as acting as the hyperlink. I have set this up a table with the ability to scroll - developer - add scroll bar to table, So when I scroll down...
  5. J

    Need Scroll VBA code to use with Microsoft DT Picker control

    Using Excel 2010, I am using the Microsoft DT Picker control on certain sheets within my workbook. The workbook is setup to automatically open on sheet "Start" regardless of which sheet the workbook was last saved on. When reopening file and I select a sheet that utilizes the DT Picker control...
  6. F

    How to make than A1 be selected when we open every worksheet ?

    Hi, I use files that sometimes I use and forget to come back to A1. When I open back this files, I want every worksheet select A1 in order not to have to scroll down and go left all the time. Any way to do it ? PD : It must be automaticall. I don't want to have all the time to press CTrlQ.

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...