Hi guys,

I have a formula on a cell A1 and have a VBA code running on the same worksheet which copy and paste another cell from different worksheet to the cell A1. (See the code below)

history2Wks.Range(history2Wks.Cells(lRecRow, 0), history2Wks.Cells(lRecRow, 0)).Copy
        .Range("$A$1").PasteSpecial Paste:=xlPasteValues, Transpose:=True
        inputWks.Range("AppSel").Value = .Range("AppID").Value
        rngA.Select
But when the value from a cell in another worksheet is paseted on the the cell A1, it also breaks the formula in cell A1.

Anyone any idea????

Cheers,