| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column | Excel Programming | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
Linear Mode
