Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy text to specific cell
In one cell I have a String And in another cell I have a reference to a cell.
How do I put the String into the referenced cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy text to specific cell
A Formula will return a value to the cell that holds the formula.
You'd need some VBA to do what you want. dim myStrCell as range dim myAddrCell as range with activesheet set mystrcell = .range("a1") set myaddrcell = .range("b9") .range(myaddrcell.value).value = mystrcell.value end with --- This has no validation at all! If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Tattyfur wrote: In one cell I have a String And in another cell I have a reference to a cell. How do I put the String into the referenced cell? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=CELL("filename") VOLATILE? | Excel Worksheet Functions | |||
How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
Using 'If' refer to specific words in a cell containing text | Excel Worksheet Functions | |||
Help inserting a Cell Value in a Text Cell | Excel Worksheet Functions |