Copy row contaning matching value to another workbook - Subscript out of range error

Hey again,
I'm having a little trouble sending a row to another workbook, was wondering if someone could offer a little advice as to what I'm doing wrong? I have 3 workbooks, A,B, and C. Workbook A contains my code. The code needs to open workbook B and find a value in column BF. If that value is found, it is then to search a directory for a workbook with today's date...this is workbook C. If workbook C exists, I need to open it and copy the row that had the matching value from workbook B to the first blank row in workbook C.

I think I have the searching/opening/matching part down. I'm running into a 'Subscript out of range' error when trying to set the values of the first blank row in workbook C equal to the values of the row from workbook B. Here is my code in full

Please Login or Register  to view this content.

I'm getting the error on this line

Please Login or Register  to view this content.

Any thoughts on what I'm doing wrong? If you have a different method to suggest I'm all ears as well

Go it sorted, thanks