Hi,

I have some data & formulas in one Excel file and would like to COPY it to
another Excel file. I used the following command lines, but it is not
working. Could you please tell me why?

Workbooks("Book1.xls").Worksheets("Sheet1").Range( "B:B") =
Workbooks("Book2.xls").Worksheets("Sheet1").Range( "B:B")

Then, I tried this, but it is not working either!

Workbooks("Book2.xls").Worksheets("Sheet1").Range( "B:B").Copy
Destination:=Workbooks("Book1.xls").Worksheets("Sh eet1").Range("B:B")

Thanks.