Pausing a macro for user input
 

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 {?}

Pausing a macro for user input
 

Wayne,

Try this:

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

--
sb
"Wayne" wrote in message
...
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 {?}