I'm having trouble with the funciton call to refresh the information in a pivot table, currently the last function call in a larger piece of VBA code.

The VBA code grabs data based on a drop-down list, and puts information into a range based on the choice, that range of data is then put into a pivot table in order to sum duplicate entries. What I need at the end of the code is for the pivot table to be refreshed.

Currently, when a selection is made, the pivottable refreshes, but only the first column. The other columns require a manual refresh. Also, if the next selection has more rows than the first selection, the first column updates, but only displays as many rows as the first selection. It requires another manual refresh to refresh the data in all columns and rows.

Currently, I'm using:

Please Login or Register  to view this content.
This being the first time I've created and used my own pivot table, my knowledge of function calls to pivot table is limited.