Thread: how do i select all the visible cells only when using auto filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MartinW
 
Posts: n/a
Default how do i select all the visible cells only when using auto filter

Hi shaurabh,

If I understand you correctly, all you have to do is
copy and paste the data to a new worksheet.

HTH
Martin


Reply With QuoteReply With Quote