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

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
>

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" <(E-Mail Removed)> wrote in message
news:a8c87993-9392-47ec-8cba-(E-Mail Removed)...
> 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

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)" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:a8c87993-9392-47ec-8cba-(E-Mail Removed)...
>> 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
>