Macro to Create Pivot in Multiple Workbooks (Differing range sizes)

I created a macro that goes through a workbook and creates a macro based on one of the sheets. I ran this over 100 times, and realized that the first time I recorded it, the macro saved so that it only grabs a certain portion of the data I want (e.g., the first set of data had 300 rows, and the subsequent sets of data might have had 500-700-900 rows..). THerefore, a lot of my data is wrong.

How do you adjust VBA code to dynamically grab the correct data when creating a pivot table?

Here is the code:

Please Login or Register  to view this content.