Auto Paste Special VB Code

[FXA]

How do I get this to work in Excel?

ActiveSheet.PasteSpecial Format:="TEXT", Link:=False, DisplayAsIcon:= _
        False, NoHTMLFormatting:=True

Thank you in advance

 

[zero269]

How do I get this to work in Excel?

ActiveSheet.PasteSpecial Format:="TEXT", Link:=False, DisplayAsIcon:= _
        False, NoHTMLFormatting:=True

Thank you in advance

What are you trying to do exactly? Paste Values Only (Text) from the Clipboard to the Active Cell?

 

[FXA]

What are you trying to do exactly? Paste Values Only (Text) from the Clipboard to the Active Cell?

Yes, instead of right clicking, want it to automatically do this when pasting

 

[rlv01]

Perhaps this?

How to set paste values as default paste when using Ctrl + V in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

 

[FXA]

Perhaps this?

How to set paste values as default paste when using Ctrl + V in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

I will check it out, thank you

 

[FXA]

Perhaps this?

How to set paste values as default paste when using Ctrl + V in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

I followed the instructions but unfortunately it is only for 2013 and a solution for 2016 and doesn't work in 365. I get the solution but the VB code has to be different for 365 and that I am not very familiar with.

 

[MARK858]

The original code works fine for me in 365, have you actually copied any cells before using the Ctrl + v?

 

[FXA]

The original code works fine for me in 365, have you actually copied any cells before using the Ctrl + v?

Yes, tried both a single cell and multiple cells

 

[MARK858]

What module did you put the code in?

 

[rlv01]

I followed the instructions but unfortunately it is only for 2013 and a solution for 2016 and doesn't work in 365. I get the solution but the VB code has to be different for 365 and that I am not very familiar with.

I ran it under 365 and it works for me.