S
snax500
In Excel2000, I have the following (see below) macro to add apostrophes
to a selected range. After running the macro, my arrow (navigation)
keys stop working. If I then go to another file they stert up again. I
DO NOT have any Transistion keys enabled. Any ideas on how I can fix
this?
Thanks
Sub add_appostraphe()
Dim myinput
On Error GoTo finit
Set myinput = Application.InputBox(prompt:="Select a range that needs
an apostrophe", Type:=8)
For Each cll In myinput
n = cll.Value
cll.Value = "'" & n
Next
finit:
End Sub
to a selected range. After running the macro, my arrow (navigation)
keys stop working. If I then go to another file they stert up again. I
DO NOT have any Transistion keys enabled. Any ideas on how I can fix
this?
Thanks
Sub add_appostraphe()
Dim myinput
On Error GoTo finit
Set myinput = Application.InputBox(prompt:="Select a range that needs
an apostrophe", Type:=8)
For Each cll In myinput
n = cll.Value
cll.Value = "'" & n
Next
finit:
End Sub