I have a table in Sheet "Code". In column C i have some country code like DE,FR,GB...I just want to select all the values and make at as visible in pivot table which is available in the Main sheet. I used the code below but not working and not showing error. Help me to change my code.I have a table in Sheet "Code". In column C i h