Macro calculate only a cell or a range of cells on multi sheets

[ste33uka]

Hi my workbook has 55 sheets, the 1st 5 sheets are different names which i dont want macro to run on.
the next 50 sheets are named 1,2,3,4,5,6,7 and so on.
Would anyone have a macro that would calculate cells (iy4:iy75) (c4:c75) and J4,J8,J12 on all 50 sheets named 1,2,3,4,5,6,7.........
Thanks

 

[maabadi]

1.what is Name of your first 5 sheets. Write here. we need them for macro.
2. what formula you have to calculate for each ranges that you told.

 

[ste33uka]

1.what is Name of your first 5 sheets. Write here. we need them for macro.
2. what formula you have to calculate for each ranges that you told.

formulas are all different,
1st name is 1
then 2,3,4,5,6 and so on

 

[mohadin]

Try something like this

Sub test()
Dim i As Long
    For i = 1 To 50
        With Sheets(CStr(i)).Select
       
'             Do the calculation you need

        End With
    Next

End Sub

 

[ste33uka]

Try something like this

Sub test()
Dim i As Long
    For i = 1 To 50
        With Sheets(CStr(i)).Select
      
'             Do the calculation you need

        End With
    Next

End Sub

Thanks alot, thats what i was looking for.

 

[mohadin]

You are very welcome
And thank you for the feedback
Be happy