+ Reply to Thread
Results 1 to 8 of 8

How to make a sheet scroll to the last row with data once a button is clicked?

  1. #1
    Forum Contributor
    Join Date
    07-09-2018
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    257

    How to make a sheet scroll to the last row with data once a button is clicked?

    From E24:E200 i have data, by using a button how make the sheet scroll down to the last row with data?

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,073

    Re: How to make a sheet scroll to the last row with data once a button is clicked?

    How about one of these
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-09-2018
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    257

    Re: How to make a sheet scroll to the last row with data once a button is clicked?

    Hi, its scrolling down to the last cell in the table but not considering if the cell has data.

    Such as only between E4:E200 have data and table E goes up to E300 it scrolls down to E300.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,073

    Re: How to make a sheet scroll to the last row with data once a button is clicked?

    In that case how about
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-09-2018
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    257

    Re: How to make a sheet scroll to the last row with data once a button is clicked?

    Its possible to make the code ignore data with formula and count only the result produced by the formula, such as ignore cell in blank with formula?
    Last edited by Mr.Castle; 09-15-2018 at 03:22 PM.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,073

    Re: How to make a sheet scroll to the last row with data once a button is clicked?

    That's what the last code do, if it's not, can you please upload a sample workbook.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  7. #7
    Forum Contributor
    Join Date
    07-09-2018
    Location
    Germany
    MS-Off Ver
    2016
    Posts
    257

    Re: How to make a sheet scroll to the last row with data once a button is clicked?

    After many attempts, the code worked Well.

    Thank you for your help.

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,073

    Re: How to make a sheet scroll to the last row with data once a button is clicked?

    Glad it's sorted & thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Change color of scroll bar on listbox when button clicked
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2018, 01:58 PM
  2. [SOLVED] How to make the scroll bar button dynamik
    By status1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-16-2017, 07:57 PM
  3. [SOLVED] Make button move when clicked
    By ed67 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2015, 09:02 AM
  4. [SOLVED] How to make a non-macro button/checkbox that when clicked will copy value out of that cell
    By ladydubs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2013, 12:44 PM
  5. [SOLVED] UserForm Command Button - how to make it change appearance when clicked
    By schmidt62 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2012, 10:53 AM
  6. Make clicked button go bold and other choices go gray
    By szfoster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2009, 03:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1