LinkBack URL
About LinkBacks
Is there a function to cut a cell and then paste that cell to another cell?
Is there a function to cut a cell and then paste that cell to another cell?
Ctrl + X
Go to another cell
Ctrl + V
Life's a spreadsheet, Excel!
Say thanks, Click *
How can i insert that in a formula?
It is not possible to do that using the built-in worksheet functions.
I'm not sure if that's even possible with a VBA user defined function.
Let me see if I can attract the attention of some of the VBA programmers.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Excel formulas and functions cal only run calc's/tests, they cannot affect other cells, and they cannot cut and paste anything, anywhere. You could probably record a macro that will do that for you, if it is a standard operation that you do frequently
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I'm technically not the worst programmer on the board. Maybe I can help.
Are you trying to copy the cell's formula from point A to point B, or just a given cell's value?
Here's an example pulling the cell formula.
In any given cell on the worksheet, just type PullFrom followed by the cell reference. PullFromB3 would instantly transport B3 to current cell.
Please Login or Register to view this content.
Last edited by daffodil11; 05-14-2015 at 06:00 PM.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
It works in VBA but not on the sheet:
Here's how I tested it:Please Login or Register to view this content.
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
just the value.Originally Posted by daffodil11
I'm technically not the worst programmer on the board. Maybe I can help.
Are you trying to copy the cell's formula from point A to point B, or just a given cell's value?
Here's an example pulling the cell formula.
In any given cell on the worksheet, just type PullFrom followed by the cell reference. PullFromB3 would instantly transport B3 to current cell.Please Login or Register to view this content.
Actually what I want to do is it;
I want to transfer my data stored in MS Word files into MS Excel. MS Word data include two column. I've written the second column after a couple of column gap by pressing TAB.
When I copy-paste the MS Word Data to Excel second column elements don't occupy on the second column rather third, fourth or fifth column.
I want to write a function or macro to cut-paste them onto 2nd column in excel.
I created a special cut and paste macro which;
1) find the latest used columns in a row
2) then cut those and paste on B column respectively
it gets error as you see. What's wrong? How to fix it?
Hi Zanshin,
Just a small alteration or two
Please Login or Register to view this content.
Last edited by xladept; 10-20-2015 at 04:10 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks