Macro not copying cell data from one spreadsheet to another.

[bherbert]

I have created a macro in excel spreadsheet A that I want to open Excel spreadsheet b. I want to get the data from column b row 10 in spreadsheet B. The problem that I am having is there is a function in Column B row 10 Spreadsheet B. Each time I try to copy its getting the function not the data? Can this be done and if so how?

[PMO]

Hello,

If your code is as below

Please Login or Register  to view this content.

replace by

Please Login or Register  to view this content.

Best regards.

PMO
Patrick Morange

[ChemistB]

Oops, was trying to make a new post.