MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pulling out my hair!

Posted by R.Brayton on July 10, 2001 10:25 PM

Please, in plain english can anyone tell me how to move data from one cell to another without dragiing it or copy and paste. I can't find a move formula/function anywhere.
Thank you

Posted by Richard S on July 11, 2001 12:34 AM

Have you tried edit,cut, paste, or is that not what you're on about. You can also use paste special to only paste values or formulae or whatever.

Posted by Mark W. on July 11, 2001 7:16 AM

Excel Formula/functions don't perform such tasks --
that's the purpose of a command. Dragging is a GUI
implementation of Cut/Paste. Cut, Copy and Paste are
Excel commands found in the Edit menu. Functions
only return values to the cells in which they are
entered -- they perform no other "actions".

Posted by Tuc on July 12, 2001 8:48 AM

In VBA you have a Copy method. It takes an optional variable for the destination.
You could do something like Range("A1").Copy Range("A5"). This would copy the cell from a1 to a5.
If you had multiple cells then it could look like Range("A1:B2") Range("a5")
You could also specify a destination on another worksheet. Range("A1:B2").Copy worksheet("Sheet2").Range("A5")
If you do not specify a destination the copy would be to the clipboard.
Once it is on the clipboard you could call the pastespecial method.
Does this help?


Posted by George A. on July 12, 2001 3:22 PM

i am not exactly sure what you are looking for.
What about referencing the original cell and then
do a copy - paste special value over it and then deleting
the originl cell.