cancel
Showing results for 
Search instead for 
Did you mean: 

# Not Assigned : Is it possible to remove this?

henry_jones
Participant
0 Kudos

Is it possible remove the "# not assigned" values and just show a blank?

Accepted Solutions (1)

Accepted Solutions (1)

former_member188325
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Here you can find simple code for VBA.

CIAO!

former_member188975
Active Contributor
0 Kudos

Hi Hank,

Please refer to this link:

Hope this helps...