Dim var As Variant
Dim ans as Long
var = 37
ans = MsgBox (var & " is Row Number, is this correct", vbYesNo)
if ans = vbNo then _
exit sub

--
Regards,
Tom Ogilvy


"rleonard" wrote in message
...
Need to change so that If 37 is incorrect Ican stop or cancel running of
Macro.

the number "37" is changed by using Edit Find & Replace while editing
macro

Dim var As Variant
var = 37
MsgBox var & " is Row Number"

thanks
Bob Leonard