View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mauro Mauro is offline
external usenet poster
 
Posts: 11
Default Not deleting headers

as an aswer to a previous question I've received the following code:

Dim c, sh
For Each sh In ThisWorkbook.Sheets
If sh.Name < "Main_Sheet_Name_Here" Then
For Each c In sh.UsedRange
If Not c.HasFormula Then c.ClearContents
Next c
End If
Next sh

this works fine. The only problem being that row 1 shouldn't be deleted as
it is the header. How can I do that?

thanks