From E24:E200 i have data, by using a button how make the sheet scroll down to the last row with data?
From E24:E200 i have data, by using a button how make the sheet scroll down to the last row with data?
How about one of thesePlease Login or Register to view this content.
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.
In that case how aboutPlease Login or Register to view this content.
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.
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.
After many attempts, the code worked Well.
Thank you for your help.
Glad it's sorted & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks