Stop copying data when it hits "(Blank)" rows in pivot table

Hi,

Does anyone know what the vba code to stop copying data once it hits "(blank)" in a pivot table. So it looks like something in the pic.

example.jpg

This is my code. Thanks!

Please Login or Register  to view this content.