Working like a charm now! I just needed to record a new macro and assign the shortcut to it, then press CTRL+V (after having copied the relevant data to the clipboard), then run the macro you made, and voila! So now the new macro is:
Quote:
Sub Macro1()
'
' Macro1 Macro
'
'
Application.Run MacroName:="Reformat"
End Sub
|
Many thanks!!!!