How to create by 1-100 row to 1 sheet then loop next to...

[Faozan]

1-100 = sheet(1)
101-199 = sheet(2)
200-299= sheet(3)

 

[mohadin]

Hi
Try

Sub test()
Dim i&
    For i = 1 To 300
        Select Case i
        Case Is <= 100
         ' Code for sheet1
        Case Is <= 200
             ' Code for sheet2
        Case Is < 300
              ' Code for sheet3
        End Select
    Next
End Sub

 

[Faozan]

Hi
Try

Sub test()
Dim i&
    For i = 1 To 300
        Select Case i
        Case Is <= 100
         ' Code for sheet1
        Case Is <= 200
             ' Code for sheet2
        Case Is < 300
              ' Code for sheet3
        End Select
    Next
End Sub

If loop next to infinity? By conditions cut 100 to 1 sheet ?

 

[Georgiboy]

Do you want to put the numbers onto the sheets as below?

Sub test()
    Dim x As Long, s As Long
    
    For x = 1 To 300 Step 100
        s = s + 1
        Sheets(s).Range("A1:A100") = Evaluate("SEQUENCE(100,1," & x & ",1)")
    Next x
End Sub

 

[Faozan]

Do you want to put the numbers onto the sheets as below?

Sub test()
    Dim x As Long, s As Long
   
    For x = 1 To 300 Step 100
        s = s + 1
        Sheets(s).Range("A1:A100") = Evaluate("SEQUENCE(100,1," & x & ",1)")
    Next x
End Sub

This will loop infinity or not?

 

[Georgiboy]

No, it will put:
1 to 100 in sheet1
101 to 200 in sheet2
201 to 300 in sheet3

 

[Faozan]

No, it will put:
1 to 100 in sheet1
101 to 200 in sheet2
201 to 300 in sheet3

How to loop every 100 to every sheet?

 

[Georgiboy]

Loop to do what?

Your original post is so short you are leaving us guessing at what it is you want to do.

Also
1-100 = sheet(1) = 100 cells
101-199 = sheet(2) = 99 cells
200-299= sheet(3) = 100 cells
299 cells in total.

 

[Faozan]

Loop to do what?

Your original post is so short you are leaving us guessing at what it is you want to do.

Also
1-100 = sheet(1) = 100 cells
101-199 = sheet(2) = 99 cells
200-299= sheet(3) = 100 cells
299 cells in total.

Input 1-100 to 1 sheet and then loop like this.

 

[Sanjeev1976]

Input 1-100 to 1 sheet and then loop like this.

This you want in how many sheets. Since it cannot loop to infinite sheets, which does not help in any way