e.g. I want Cells(1,1) to be equal to [anotherworkbook.xls]anotherworksheet'!Cells(1,1)
How should I write the code.

Thanks guys