[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

    End Sub


Participate now!

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