Macro that steps, but won't run!

System = Excel 2003, VB 6.3, Pent 4 2.9 ghz, 1.5 GB RAM, 21 GB free on HD (out of 40GB total)

I have a spreadsheet that has about 10 tabs.

To update each pivotable in each tab, I run the following code.

At the same time, I want to readjust the column sizes (after updating the pivots, they expand too much due to header) This is where the problem lies.

The Code will allow me to Step through it successfully, the columns resize, but will not RUN correctly!

Here is the simple code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Any help would be greatly appreciated!

The forum Rules state that you must wrap your code in Code Tags!

Your code for resizing is outside the loop, so it won't work on each sheet.

Try this instead

Please Login or Register  to view this content.