title: Compler Error while compiling the VBA Code
body: <pre><code>Sub tem()
  Function removeSpecial(sInput As String) As String
      Dim sSpecialChars As String
      Dim i As Long
      sSpecialChars = "\/:*?""&lt;&gt;|"
      For i = 1 To Len(sSpecialChars)
          sInput = Replace$(sInput, Mid$(sSpecialChars, i, 1), " ")
      Next
      removeSpecial = sInput
  End Function
  
  End Sub
  </code></pre>