Yes, I know, but I'm allowed to be here if it helps for work.

I have a macro that creates a pivot table for me, which is lovely. However, the number of lines of data from which I create the pivot table changes every month, yet the macro for the pivot table wants a definite range, rather than just letting me go to the last active cell. How do I work the changing size of the data in to the macro rather than waiting for the macro to run and then altering it manually?

Boom shanka,

Judge_B xx