Add another line under previous Hello, I have a client that has the following macro created Sub AddL

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Order a Similar Paper Order a Different Paper

Add another line under previous

Hello, I have a client that has the following macro created

Sub AddLine()

‘ AddLine Macro

‘ Keyboard Shortcut: Ctrl+a

    ActiveWorkbook.Names.Add Name:=”marker”, RefersToR1C1:=”=Sheet1!R32C1″

    ActiveWorkbook.Names(“marker”).Comment = “”

    Application.Goto Reference:=”blank_line”

    Selection.Copy

    Application.Goto Reference:=”marker”

    ActiveSheet.Paste

    Range(“A33”).Select

    Application.CutCopyMode = False

    ActiveWorkbook.Names(“marker”).Delete

End Sub

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