Defining output range

Hi Blair

To do this you would need to do the following:

1. Create the form with the required input methods (Text box or Combo box) to enter the fields to be displayed on the pivot table

2. In the program's module create Public variables to hold the information entered on the form

3. Write the Pivot table code using the variables in the PivotFields code lines

4. Place an OK buton on the form that when clicked passes the information entered to the variables and runs the Pivot Table code to create a Pivot table to reflect the requirements.

Hope this helps

Carlos