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

Post your code so we can see what you are up to...
--
HTH...

Jim Thomlinson


"priceyindevon" wrote:

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?