Add another line under previous
Hello, I have a client that has the following macro created
‘ AddLine Macro
‘ Keyboard Shortcut: Ctrl+a
ActiveWorkbook.Names.Add Name:=”marker”, RefersToR1C1:=”=Sheet1!R32C1″
ActiveWorkbook.Names(“marker”).Comment = “”
Application.CutCopyMode = False
What they would like to do is use the shortcut key CTRL+A to add another line under the previous line. Whenever they enter CTRL+A it writes overtop of the line just created. I hope my explanation makes sense.
Thanks for everyone’s help !!