jaja714 Posted February 25, 2021 Share Posted February 25, 2021 (edited) 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 February 25, 2021 by JLogan3o13 *** SORRY ... I got it working *** Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted February 25, 2021 Moderators Share Posted February 25, 2021 @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 comment Share on other sites More sharing options...
water Posted February 25, 2021 Share Posted February 25, 2021 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now