Jump to content

Finding last row in an excel column


Recommended Posts

Sorry to resurrect after so long but I can't get this to work.  I want to consolidate data from daily workbooks into a master workbook by opening each daily workbook, grabbing all rows from the activesheet and then pasting it at the end of the master book.  Here's my idea so far but the "specialcells" line is yielding a "The requested action with this object has failed.:" run-time error.

 

 

Edited by JLogan3o13
*** SORRY ... I got it working ***
Link to post
Share on other sites
  • Moderators

@jaja714 In the future, please don't hijack a thread (especially after almost 7 years). Create your own thread instead.

"Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball

How to get your question answered on this forum!

Link to post
Share on other sites

Please check the wiki https://www.autoitscript.com/wiki/Excel_Range#Last_Cell
The second example returns the last cell in a given column.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2021-06-05 - Version 1.5.4.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2021-06-14 - Version 1.6.5.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...