Quote Originally Posted by Izandol View Post
Do you have Sheet1 in your workbook?
Quote Originally Posted by Norie View Post
That error doesn't look as if it would be caused by not having the correct version of a library.

Why not use late-binding anyway?

I fixed it by changing

SQL = "SELECT * FROM [YIELD_FORMATTED$C1:BC100000

to
SQL = "SELECT * FROM [YIELD_FORMATTED$C1:BC10000

But I really want to copy from B1-IV80. Any tips?