How to copy this to another cell exactly?
 

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

How to copy this to another cell exactly?
 

copy the cell and then paste special, formula.

"cyberdude" wrote:

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

How to copy this to another cell exactly?
 

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

How to copy this to another cell exactly?
 

I misread your question (you wanted a VBA solution); but, in re-reading it,
I'm not entirely sure what you want to appear in your new cell. If you want
just the formula's text, but for it not to be an active formula in the new
location, then this may do what you want. I'm assuming your formula is in A1
and you want to put it in C7...

ActiveSheet.Range("C7).Value = "'" & ActiveSheet.Range("A1").Formula

Rick



"Rick Rothstein (MVP - VB)" wrote in
message ...
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