I have the following macro (simplified, of course):
==================
Sub Macro1()
Macro1 Macro
Keyboard Shortcut: Ctrl+s
Range("A1:a15").Select
Selection.Copy
End Sub
====================
I would like to substitute a formula (match("the end",A1:a100)) for the
"a15", but can't find the correct syntax.

Can anyone help?

Thanks.