Remember the last thing copied

Sara00712

New Member
Joined
Oct 31, 2019
Messages
3
Hello ppl! I googled my problem before posting but couldn't find anything helpful so i decided to ask here.
Is there an option to remember the last thing i copied and paste it after doing several actions in between ?
For example > I have to copy some text and paste in one cell, than i change the row height, color fill some other cells, add new rows .. or whatever.. and then i want to paste the same text in another cell. In order to do that I need to go up, copy that once again so i can paste it. This takes me a lot of time, so i wonder if there's an option to just copy something once and keep that thing copied until i copy something else? :confused:
I'm using Excel 2016.

Thanks a lot :))
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,663
Hello,

The function key F4 allows to repeat your last action ...

Hope this will help
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
4,249
welcome to the forum

simple with VBA

1. Place in a standard module
Code:
Public CopiedText As String

Sub GetText()
    CopiedText = ActiveCell.Text
End Sub

Sub PasteText()
    ActiveCell = CopiedText
End Sub
- open VBA editor with {ALT} {F11}
- Insert Module with {ALT} I M
- paste code into the window which open up
- back to Excel with {ALT} {F11}

2. Assign shortcuts to the 2 macros
eg so that you can copy with
{CTRL} k and paste with {CTRL} q

- to assign shortcut
{ALT}{F8} \ select macro \ Options \ insert chosen letter into the box \ click OK
 

Sara00712

New Member
Joined
Oct 31, 2019
Messages
3
welcome to the forum

simple with VBA

1. Place in a standard module
Code:
Public CopiedText As String

Sub GetText()
    CopiedText = ActiveCell.Text
End Sub

Sub PasteText()
    ActiveCell = CopiedText
End Sub
- open VBA editor with {ALT} {F11}
- Insert Module with {ALT} I M
- paste code into the window which open up
- back to Excel with {ALT} {F11}

2. Assign shortcuts to the 2 macros
eg so that you can copy with
{CTRL} k and paste with {CTRL} q

- to assign shortcut
{ALT}{F8} \ select macro \ Options \ insert chosen letter into the box \ click OK

Thank you, thank you, thank you!!! It worked!! :):):)
 

Forum statistics

Threads
1,077,856
Messages
5,336,798
Members
399,103
Latest member
PX04

Some videos you may like

This Week's Hot Topics

Top