Copying text between cells/worksheets
Posted by kip hamilton on October 15, 2001 3:38 PM
I'm a new user, but I figured out how to copy numerical data between cells using the "=cell ref".
My problem is that I need to copy text entries and the "=cell ref" thing only deposits itself in my targeted cell, not the data I wanted.
I can't find <help> instructions on how to copy text data between cells.
HELP!!!!!
Posted by Jonathan on October 15, 2001 5:38 PM
For example,
Range("B16").Copy Range("C16")
will copy whatever is in B16 (I used text in B16 to test this) into C16. Notice the <space> between the method (viz. Copy) and the destination range.
HTH
Posted by Jonathan on October 15, 2001 5:39 PM
For example,
Range("B16").Copy Range("C16")
will copy whatever is in B16 (I used text in B16 to test this) into C16. Notice the -space- between the method (viz. Copy) and the destination range.
HTH
Posted by Gyula Lorant on October 16, 2001 12:33 AM
I think that Kip is looking for a worksheet formula, not VBA code.
If "=cell ref" is displaying the formula instead of the result, then the cell must be formatted as Text and probably all that needs to be done is to re-format the cell as General (and re-enter the formula).
: I'm a new user, but I figured out how to copy numerical data between cells using the "=cell ref".
Posted by Don C on October 16, 2001 5:41 AM
You can't just do a copy and paste? That would give a static copy (won't change if the original changes)
If you want a dynamic reference where a worksheet cell reads another worksheet cell (and changes when the original does, then
='worksheet1'!A1
will read either numbers or text.
(Have both worksheets open, type the equals into the "receiving" cell, go to the "sending" worksheet and click in the cell you want to transfer.)
