can someone tell me why i am out of range here??

[fredderf81]

i am extremely frustrated with this. i can not figure out why i am receiving an error 9: subscript out of range. any help is appreciated.

Please Login or Register  to view this content.

both workbooks are open.

[AB33]

Please Login or Register  to view this content.

[Norie]

Does workbook 'test.xlsm' have a sheet with the exact name 'two'?

[fredderf81]

*smacks self* .... i've been staring at the screen too long =) thats again AB33

[Norie]

Are you sure the error was 'subscript out of range'?

If the problem was with Paste then the error should have been 'object doesn't support this method'.