View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default 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 {?}