Make Ctrl + D in German Excel with VBA. How to do it?

[vityata]

Hello friendly helping people,

Currently I am working in a German Excel, and thus the shortcuts are all confused. Howered, I need to restore the Ctrl+V shortcut for filling values in a column, because I need it badly

I have tried to record a macro and save it to my personal.xlsb, but it seems that I did not record correctly.
Can someone give me the VBA code for the shortcut in the English Excel for Ctrl+V?

 

[HolyExcel]

Hello,

try this if you want VALUES to be copied

Sub Werteeinfügen()


Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

End Sub

BR

 

[vityata]

Hi @HolyExcel,

Thank you for your input.

I want formulas as well. I want anything!
I want the same thing as Ctrl+D in the English version.
Anybody?

 

[HolyExcel]

aha..sorry

how about this command?

Selection.FillDown

or on german Keyboard STRG+U

 

[vityata]

That's exactly what I wanted!
Thanks!