How to copy this to another cell exactly?

  • Thread starter Thread starter cyberdude
  • Start date Start date
C

cyberdude

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying a Name's Contents 8
Create if partial match then copy and paste data from one cell to another 1
Convert A1 value to a sheet name and copy to it 2
To link sheet1 cell to sheet2 three rows merged cell 6
compare name in cells 3
Enter data in cell referenced in a cell 4
Altered pasting functionality 3

Back
Top