View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Bateman David Bateman is offline
external usenet poster
 
Posts: 15
Default deleting rows programmatically

I import a large amount of data into excel unfortunately there are headers
or footers interspersed with the data. Sometimes the headers take up 10
rows
and sometimes it takes up 11. Would it be best to identify through the len
function which rows to delete? How would I programmatically remove them?