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 = ""
I am working on BW 3.5 & Excel 2003