LinkBack URL
About LinkBacks
I know you can copy right with control R, but how do you copy left?
I know you can copy right with control R, but how do you copy left?
I searched the interwebz for the answer but didn't see one.
Instead, you could make your own code and assign a shortcut for it.
To use this, go to Excel, hit Alt+F11, Insert->Module, and paste the code below. Now close that window.
Hit Alt+F8 to call the macros window, select FillLeft and click 'Options...' and in the shortcut window hold Shift+R or whatever you feel like.
Now every time you hit Ctrl+Shift+R or whatever, it will copy from right.
Please Login or Register to view this content.
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!
Thanks, but this doesn't work. I want to copy to the LEFT. This looks like it moves it to the right. Could you also explain how this code works? Right now it's just making my cell value dissappear.
"Cells" is a property of the Range Object. It's parameters are row and column.
"Offset" is also a property, which steps away from a given range.
In this code we are saying "Move one column right from ActiveCell. Copy that cell. Paste it in the ActiveCell."
If you selected A1, running the macro would copy B1 into A1.
Got it, but this doesn't really replicate the function of the control R (fill right) command. This just copies one cell to the right.
Copy Right and Fill Right are worlds apart. Do you intend to select more than a single cell at a time? (example: A1:E1 would fill E1 in A1:D1?)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks