Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Replacing # values with blank for a characterstic


In my query & webtemplate I want to replace the '#' value with blank for a charactrestic.

I have read many posts on this forum, and tried them all, but I am unable to crack.

Following are the steps followed by me

go Tools-Macro-Visual Basic Editor.

Left Side you will see "This Workbook". Double click it.

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

Dim c As Range

For Each c In resultArea.Cells

If c.Value = "#" Then c.Value = ""

Next c

End Sub

I am working on BW 3.5 & Excel 2003



Former Member
Not what you were looking for? View more on this topic or Ask a question