Hello

I have the following macro where it searched for the number "213-709-8116". This number is hard coded in the macro.

I’m looking for a macro where when I copy the number to the memory and when I press the hot key to run the macro, then it SHOULD PASTE WHAT’S IN THE MEMORY and then search for that number.

How can this be done

Any help will greatly appreciated.

Thanks.


Sub Macro3()
'
' Macro3 Macro
' Macro recorded 8/19/2021 by don
'
Selection.Find.ClearFormatting
With Selection.Find
.Text = "213-709-8116"
.Replacement.Text = "RECORD BEGINS"
.Forward = True
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute
Selection.HomeKey Unit:=wdLine
Selection.MoveUp Unit:=wdScreen, Count:=1
End Sub