Click in the cell, but copy the text from the formula bar (select it, then
key in Ctrl+C), click in the cell you want to copy it to and paste it there
(key in Ctrl+V).

Rick


"cyberdude" wrote in message
...
Hi,

Suppose I enter this in a cell:

="His name is "&A3

Then, it may appear as:

His name is John

if I put John in cell A3.

So how can I copy the content:

="His name is "&A3

exactly without copying its value:

His name is John

to another cell using excel VBA?

Thank you

Dave