need error loop in pivot table routine

J

Jeff C

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
 
Top