Thread: Autofilter and VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
  
Posts: 417
Default Autofilter and VBA
JW,

Won't this copy the ENTIRE worksheet? The OP only wanted the filtered data
to be copied? You used the line:

.UsedRange.Copy ws.Range("A1")

--
Regards,
Bill Renaud



Reply With QuoteReply With Quote