to remove '#' value in Bex report

http://www.sap-img.com/business/removing-hex-sign-in-analyzer-report.htm

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
Dim c As Range
For Each c In resultArea.Cells
If c.Value = "#" Then c.Value = ""
If c.Value = "Not assigned" Then c.Value = ""
Next c
End Sub