Find certain worksheets and make changes

[shindig54]

Hello,
I have a tab called "Control"
On the "Control" tab I have a named range called "ProjectIDs"
"ProjectIDs" has a range of abut 24 rows and contains the worksheet names that would like updated when I run the macro. However, I don't always have 24 worksheet in the range filled out. I may only have 5 worksheet that I want updated, for example.
I'd like to have vba code that will make certain updates to each of the sheet in my "ProjectIDs"list.
Is tis possible?

Thanks so much

 

[shindig54]

I have the following but doesn't work

Public Sub Test()
Dim SH As Worksheet
Dim rng As Range


Set rng = Active.Workbook.Sheets("Control").Range("ProjectIDs")
For Each SH In ActiveWorkbook.Worksheets

Range("C3").Select
ActiveCell.Formula1C1 = "5"
End If
Next SH
End Sub
Does anyone know what all I am doing wrong? Thanks to anyone willing to help.

 

[Joe4]

Try this:

Public Sub Test()

    Dim rng As Range
    Dim cell As Range
    Dim ShName As String

    Set rng = Sheets("Control").Range("ProjectIDs")
    For Each cell In rng
        ShName = cell.Value
        If ShName <> "" Then
            Sheets(ShName).Range("C3") = "5"
        End If
    Next cell
    
End Sub

 

[shindig54]

Perfect, gosh thank you so much!!!!!

 

[Joe4]

You are welcome.