Thread: Deleting rows from list of files
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
italia italia is offline
external usenet poster
  
Posts: 9
Default Deleting rows from list of files
Hi Bernie-

I used the following and it did the trick.

newwb.Sheets(1).Rows("3:200").EntireRow.Delete
Thanks for your help.

Regards,
Italia

Reply With QuoteReply With Quote