Edited macro not running to Keyboard shortcut

[JJD168]

Not knowing a lot about macros, I have edited this on (below) it responds to the "Run" instruction in the Maco tool but not to the assigned shortcut "Ctrl+Shift+V"

Also, since it is close to the parent macro, can the separate worksheets be structured so that only the one relevant to that worksheet operatres (Iseem to find all macros when I look at the Tool)>

Regards and anticipated thanks.



Sub Copyandmerge()
'
' Copyandmerge Macro
' Macro recorded 12/10/2004 by .
'
' Keyboard Shortcut: Ctrl+Shift+V
'
Cells.Select
With Selection
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Range("A1").Select
ActiveSheet.Paste
End Sub

 

[headtoadie]

Changing the shortcut on the example as you have will not change the keyboard shortcut. Lines of code that begin with a single apostrophe (') are comments and thus are not executed when the macro is run.

Specific info on how shortcuts are assigned to macros can be found here:
http://www.mrexcel.com/board2/viewtopic.php?t=75315&postdays=0&postorder=asc&start=10

HT