Finding last row in an excel column

[JeffAllenNJ]

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 ***

[JLogan3o13]

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

[water]

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