Chart does not show selected row in alternative state when select from macro

[#1]

Hi experts,

I am trying to make a selection using run macro.

It worked when I am in default state and using following script

ActiveDocument.Fields("Member").Select "(100000|1000001)"

But if doesn't do the selection if I update my sheet to be a specific Alternative State. The script I used was the following.

ActiveDocument.Fields("Member","State_Sampling").Select "(100000)"

Could anyone give me some advice to see what I didn't do right?

Thanks

[marcus_sommer · Accepted solution]

Maybe only the select-criteria isn't correct and it should be:

.Select 100000 instead of .Select "(100000)"

another possibility is a typo by the state-name.

- Macus

[#3]

yea, it seemed there were some incorrectness in my script originally. I tried it again then it worked. providing the correct code below

  ActiveDocument.Fields(v_Identifer, v_StateName).Select "(" & str & ")"