"Select method of range class failed" error

Hello,

I have a macro that opens a specified woorkbook that changes every month. There are formulas which are pasted to range I1 of the new workbook to calculate the totals on this sheet. Everytime i run the code though, I get an error that says "Select method of range class failed" and Range("I1").Select is apparently the error. Here is the code... can anyone help?

Please Login or Register  to view this content.

I would declare Bkst as a Range, not a Variant.

Does the range actually have a value in it?

I do not see anything wrong except that ActiveSheets.Paste
should be ActiveSheet.Paste without the s
Check if D27 contains data of this format Book1.xls and if the file is actually opened.

Assume recently opened workbook as an activesheet that is,

a worksheet and not a chart sheet
is not protected so range I1 can be selected.

Andy,

I think you might have the answer there but im not quite sure i understand it fully... could you give me the code that your method is outlinning.

Thanks

I misread your initial code.

Maybe

Please Login or Register  to view this content.

If you are running the code from a click event of a button on a worksheet make sure the button has the TakeFocusOnClick set to false.