Group sheets between 2 identifying sheets and delete cell A14

[SpudNix]

Hi

Im trying to group a bunch of sheets between the "Starttab"and "Endtab" sheets and delete cell A14 in the grouped sheets.

Any suggestions using VBA

 

[Trebor76]

Hi SpudNix,

Instead of looping through each sheet to first group them to then clear the contents from cell A14, just clear the contents from cell A14 as you loop through i.e.

Option Explicit
Sub Macro1()
    
    Dim i As Long
    
    Application.ScreenUpdating = False
    
    For i = Sheets("StartTab").Index + 1 To Sheets("Endtab").Index - 1
        Sheets(i).Range("A14").ClearContents
    Next i
    
    Application.ScreenUpdating = True
    
End Sub

Note this has been adapted from Peter_SSs's code (thread 5) from here.

Regards,

Robert