Thread: Copy used range from one worksheet to another (and lose the pivot)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default Copy used range from one worksheet to another (and lose the pivot)
I have a pivot table on a worksheet I'm calling myWS. I'd like to copy the
used range of this worksheet to another worksheet I'm calling ResWS, but lose
the pivot. How would I do that programmatically?

Thanks,
Barb Reinhardt
Reply With QuoteReply With Quote