View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff C Jeff C is offline
external usenet poster
 
Posts: 35
Default 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