Copying this value and pasting it into another worksheet cel

[centaur63]

Target.AddComment.Text Text:="Previous Value was " & preValue & Chr(10) & "Revised " & Format(Date, "mm-dd-yyyy") & Chr(10) & "By " & Environ("UserName") 'Adds a new comment with the text. CHR(10) is a return.

How Do i copy what ever value this field is and paste it into a cell on a different worksheet?

 

[RalphA]

I'm not sure what your question is, but, assuming your answer is on Sheet1, in cell B4, and you want cell B4 on Sheet2 to show that answer, I would put, in Sheet2, cell B4, this formula:

=Sheet1!B4

Is this what you need?