Hello there,
I want to trigger inserting a new row using Ctrl + I by assigning that combination as a macro bind.
Can someone please tell me what's wrong with my code so that it works?
Thanks.
I want to trigger inserting a new row using Ctrl + I by assigning that combination as a macro bind.
Can someone please tell me what's wrong with my code so that it works?
VBA Code:
Sub InsertRow()
Application.SendKeys "(+"" "")" 'Shift+Spacebar to select the row. Space (" ")
Application.SendKeys "(%ir)" 'Alt+I+R to add a new row above.
End Sub
'For SHIFT use +
'For CTRL use ^
'For ALT use %
Thanks.