Remember the last thing copied

[Sara00712]

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?
I'm using Excel 2016.

Thanks a lot )

 

[James006]

Hello,

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

Hope this will help

 

[Yongle]

welcome to the forum

simple with VBA

1. Place in a standard module

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]

Hello,

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

Hope this will help

Noope
I don't need to repeat my last action, but to paste the last thing copied.

 

[James006]

May be the following link could help :

https://www.ozgrid.com/forum/forum/...-address-of-range-copied-to-clipboard?t=66773

 

[Sara00712]

welcome to the forum

simple with VBA

1. Place in a standard module

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!!

 

[Yongle]

Thank you for your feedback