Wait for press a key!
 

Hi All,
In VBA, how can I hold the macro until press a assigned key.
Example!
sub copy_value()
Activecell.copy
(the macro hold and waiting press a assigned key.)
activecell.select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
end if

Wait for press a key!
 

Why not give the user an Application.Inputbox so they can choose a range
into which the Paste goes ?
Check the help for relevant arguments.

NickHK

"Lotuxel" wrote in message
...
Hi All,
In VBA, how can I hold the macro until press a assigned key.
Example!
sub copy_value()
Activecell.copy
(the macro hold and waiting press a assigned key.)
activecell.select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks
_
:=False, Transpose:=False
end if