HI.
Can anyone suggest why I am having so much difficulty going back and forth between two sheets from a different workbook when writing a macro? It keeps on saying subscript out of range, object doesnt support this proeprty etc.
All I need to do is copy something from workbook B, delete the contents on sheet2 on workbook A and paste the copied code on sheet2.
It seems like such a straightfoward thing to do but for some reason nothing seems to work and it is very frustrating.
Have I got some setting I need to change?
Thanks,
RET79
Can anyone suggest why I am having so much difficulty going back and forth between two sheets from a different workbook when writing a macro? It keeps on saying subscript out of range, object doesnt support this proeprty etc.
All I need to do is copy something from workbook B, delete the contents on sheet2 on workbook A and paste the copied code on sheet2.
It seems like such a straightfoward thing to do but for some reason nothing seems to work and it is very frustrating.
Have I got some setting I need to change?
Thanks,
RET79