How to start execution from ActiveShett

[gopdeep]

Hi

If am having "N" number of sheets in my workbook, my code should run from active sheet to the last sheet of the workbook.

For instance, consider that my workbook having sheets such as "Sheet1, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6, Sheet7 & Sheet8" here if "Sheet3" is in active means then my code should run from "Sheet3 - Sheet8" and shouldn't run for "Sheet1, Sheet2".

Can anyone help me on this condition ?

Am breaking my head to get an clear code for above condition

 

[pgc01]

Hi


Try:

Sub test()
Dim ws As Worksheet
 
For Each ws In Worksheets
    If ws.Index >= ActiveSheet.Index Then
        ' your code
    End If
Next ws
End Sub

 

[gopdeep]

yeap... its working...