copy from a cell in one spreadsheet to another only if there is not a formula.

I am attempting to copy a column of cells but only if they don't to have a formula in them if they do I want to skip to the next cell. My code fail when I try to set the cell to do a .HasFormula

Please Login or Register  to view this content.

Try this line

Please Login or Register  to view this content.

it fails here

Please Login or Register  to view this content.

Turtleman,
I am not surprised it has failed. The code appears more complicated than it should be, assuming you are working on the same book. I suspect, you are looping though Column A and testing the cells if they have formulaa. If this is the case, the code could be simplified.

Nope 2 different books. If it was one book it would be easy.

Thanks I will give it a try.