Pivot Table Worksheets

  • Thread starter Thread starter Lambtwo
  • Start date Start date
L

Lambtwo

My workbook creates a series of worksheets (for each division) from a pivot
table. In addition, there are 3 data worksheets that follow the pivot table
created worksheets.

I want to run a macro on the pivot worksheets only (not the last 3 data
sheets). Fumbling around with the For Each and trying to exclude the last 3,
but can't seem to make this work.

Help please ...
 
Possibly:

for i = 1 to sheets.count - 3
set sh = sheets(i)
Next

or something similar.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

refresh multiple pivot tables in workbook 2
Used Range and Source data of a Pivot Table 1
VBA Pivot Table Change Criteria - Help?! 1
Unable to Group in Pivot Table 1
Macro to update pivot table data range 3
Multiple Worksheets Protection 1
Refreshing external data on individual sheets in a specific sequen 1
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3

Back
Top