Pausing a macro for user input

[Wayne]

What is the command to pause a macro so user can input a
line number that changes with each use of the
spreadsheet. Old Lotus command was {?}

 

[steve]

Wayne,

Try this:

Dim x As Long
x = InputBox("What line?", "")
Rows(x).Select