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
|