Oops, sorry for confusion! :(

I want the code that allows me to do the same things as what I choos
from the Table Option (using pivot table) -- "For empty cells, show
0"

P.S. I start dealing with pivot table in code 2 days ago, and I am ne
to it.

Thanks

--
Message posted from http://www.ExcelForum.com