on 02-07-2006 7:02 PM
Is it possible remove the "# not assigned" values and just show a blank?
Hi,
Here are the steps to do the same
1) In excel menu Tools->macro
2) Enter the macro name say SAPBEXonRefresh
3) click 'create', will go to visual basic editor
4) To display '#' as '', paste the following code
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
5) Close the editor and click on refresh again.
refer this link which solved the probelm.u have to paste the code as it is.and enter the macroname exactly as mentioned above.
to remove 'not assigned' ,u have to insert one more line for this code after <i>If c.Value = "#" Then c.Value = ""</i>
If c.Value = "Not assigned" Then c.Value = ""
<i>Next c</i>
Hope this helps.
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here you can find simple code for VBA.
CIAO!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.