[Solved] How do I get the nth row result

  • I am trying to pull out the result every 4 rows down a spreadsheet. I'm sure theres a function to do this.


    any help would be gratefully appreciated.

  • This probably belongs in the Excel forum since you do not mention using a database so for a spreadsheet the basic format for a coded solution would be;


    Sub Get4thRow()


    Dim i As Integer
    i = 0
    For i = 4 To 100 Step 4
    'code to do whatever you want here
    Next



    End Sub



    HTH

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!