View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
priceyindevon priceyindevon is offline
external usenet poster
 
Posts: 4
Default using macro to copy and paste filtered results, what if blank?

I have a sheet with 500 lines that are filtered for late deliveries, when
there are no late deliveries my macro can not paste to another sheet blank
results. How do I get round this problem?