need error loop in pivot table routine
 

When generating pivot tables with VBA, if the loop hits a record with no data
the routine stops with the "This command requires two rows of data . . ."
error.

Can someone suggest a VBA solution so the routine will skip this record
moving on to the next?

Thanks in advance




--
Jeff C
Live Well .. Be Happy In All You Do