Pivot Table Source Data

[foxy_420]

Hello everyone,

I am looking to find a way to change my pivot table source data (right now I have it hard coded).

For example the number of rows could potentially change (ie. from as little as 1 all the way to potentially 100000, or X).

Is there anyway to make sure it grabs all the information up to the LAST row?

Here is the code I have (that is hard coded to pull until row 89).

Please Login or Register  to view this content.

Thank you guys

[marreco]

i find this, try adapt

Please Login or Register  to view this content.

Or
http://www.waldherr.org/create-pivot...source-ranges/

[Regenbui]

Try the code below. I just select the entire column, so i'm sure that all data is used:

Please Login or Register  to view this content.

[foxy_420]

Thanks for the responses guys, I have tried it but it didn't seem to work that well for me.

Here is the entire code I have for context:

Please Login or Register  to view this content.

Thanks again