selecting blank cells in a column in a pivot table

[Blackoutlaw]

I have a pivot table and would like to use a macro to individualy select the blank cells in the last column so that it creates the separate tables just like when you double click the blank cell. The number of blank cells will change and location will not always be in the same place. Thanks for the help.