While writing files from another workbook, keep empty cells empty!

[nivoe]

Hello everyone

First off the code:

Please Login or Register  to view this content.

With this code, I write all Data from Sheet1 in A.xlsx into Sheet1 in Main.xlsx.
It is working perfectly with one exception.

If, e.g. in A.xlsx there are empty cells, the cells in Main.xlsx show zeros (=0).

How could I make it that empty cells in A show as empty cells in Main?

Help is much appreciated
Cheers

[Norie]

Do you want to have formulas linked to A.xlsx?

Or would the values be OK?

Please Login or Register  to view this content.

[nivoe]

All I want is to get the values (but to keep the conditional formatting in Main.xlsx)

If your above code is like a manual copy and paste (which overwrites cond. form.) I cannot use it.

Cheers

btw. you above line (wbA.Worksheets("Sheet1").Range("A1:ET2000").Copy
) throws an exception:

Run Time Error 91, Object Variable or With Block Variable not set

[Norie]

Why can't you use what I posted?

All it does is copy and paste values, it doesn't overwrite any formatting.

there were a couple of typos.

Please Login or Register  to view this content.

[nivoe]

Norie

You are a life saver. It works. Thank you very much!

Have a nice day