View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default How do I create a list from another list with exclusions (such as blank cells)?

If you have lots of data (hundreds or thousands of rows), then you might
want to add the following line somewhere at the top of the program (I
forgot to add it):

Application.ScreenUpdating = False

--
Regards,
Bill Renaud