Excel VBA Runtime error 1004 "Select method of Range class failed"

Hi :) Can anyone explain why I get a Excel VBA Runtime error 1004 "Select method of Range class failed" when I run the code below? Every time it runs it stops on the line shaded red below. IAPLUS = Workbooks("New Members.xls") Set IAPLUSSht = IAPLUS ...

www.excelforum.com