I have the following code. It works wonderfully, although upon actually using the macro a few times I've noticed one error. I have it copying the formatting of the previous row (I think) and there is one column that I do not want the value copied from (row I). The range that I want copied over contains the formula that I want in that cell, however when I copy it over, if the cell above where the new data is pasted says "COMPLETE", it overwrites the formula and enters COMPLETE in the cell. How would I correct this?

Please Login or Register  to view this content.
Thanks