View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jln via OfficeKB.com jln via OfficeKB.com is offline
external usenet poster
 
Posts: 88
Default Problem with code

OK i have a macro that does an auto filter and counts takes the results and
pastes the rows that i have set over to another page. The probelm is that
when the auto filter come back with ne results it pastes everthing. What can
i do to stop this?

I have tried counting before the filter and after and comparing the totals
and do if = then exit sub with no luck.
I have tried a msgbox with a yes no and that didnt work.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1