Empty Data Issue

[ajc5382]

I have a program written that pulls prices for the value of contracts Jan-Dec, each day of the year. ( Meaning theres a price today for contracts in jan, feb, mar....etc). My problem is how to bypass empty data, for say, christmas which will yield a row of 12 0's (ex. 1/25/2012 will have a 0 for jan, feb, mar.......bc the market is closed.)

What I need is a way to bypass this issue in doing my calculations. Will a do while loop using the "isempty" function work??

 

[andrewkard]

Hello, maybe so:

Sub test()
    Dim i&
    For i = 1 To 10
        If Cells(i, 1).Value = 0 Then GoTo NxtI
        ' your code here
NxtI:
    Next i
End Sub