Hi, I have recorded a macro where the end result is a pivot table being produced. The array of cells that the pivot table reads from can vary in size. How can I get around this?

any help much appreciated
Liam