Pausing a macro for user input

Wayne · Oct 24, 2003

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 · Oct 24, 2003

Wayne,

Try this:

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