On Jul 17, 7:54 am, Allen wrote:
I've got a macro that for a selected agency will find the city/state
associated with that agency and then chooses that state in a pivot table.

For some reason things are no longer working. The macro seems to choose the
state in the pivot table, but the pivot table then shows no data. If I
manually select a different state the pivot table will populate with data and
then I can manually re-select the correct state using the drop down menu and
it will also work. It just doesn't seem to work when I have the macro select
it.

Any ideas on what I'm doing wrong or how I can fix this?
It doesn't appear to be a trailing space issue, fwiw.

It is hard to tell what is wrong with something like this without
seeing the section of code that you think should be working. I do
this with several tables. I have pivot tables that cycle through all
the page fields and format the reports onto separate sheets.

Peter