I have a pivot table that looks something like this:

Product1 Product2 Product3
Week1 2500 500 0
Week2 200 35 800
Week3 150 5000 3

Where the numbers are quantities of their corresponding product required by
week. In my current code I have variables that contain the column name and
the row name (i.e. varProduct and varWeek). How do I get the value of the
quantity that corresponds to the variables?

Thanks!
--

-------JKY<-------