Defining scope of functions.

so when the IF is true, you want total to equal total + ..., and also execute the select portion? If that is the logic then how about:

If Cells(x, 1).Value = "" Then

Total = Total + Cells(x, 9).Value

    Select Case step

    Case 1
        Cells(9, 13).Value = Total

    Case 2
        Cells(12, 13).Value = Total
        
    Case 3
        Cells(15, 13).Value = Total

    Case 4
        Cells(18, 13).Value = Total
    
    Case Else
        Cells(21, 13).Value = Total

    End Select
    Total = 0
    step = step + 1
End If

if is true -> total = total +
if is false -> select case & reinitialization of total & increment step

You missed the "else"

(this is part of a small loop)

EDIT:

here is how I would do this in PHP (hopefully will make things clearer)

PHP Code: 

If($cell1 = ""){
    $total = $total + $cell2;
}
else{
    switch($step){
        case 1:
        cell3 = total;
        break;

        case 2:
        cell4 = total;
        break;

        //etc
    }
    total = 0;
    step++;
} 


If Cells(x, 1).Value = "" Then

Total = Total + Cells(x, 9).Value

Else

    Select Case step

    Case 1
        Cells(9, 13).Value = Total

    Case 2
        Cells(12, 13).Value = Total
        
    Case 3
        Cells(15, 13).Value = Total

    Case 4
        Cells(18, 13).Value = Total
    
    Case Else
        Cells(21, 13).Value = Total

    End Select
    Total = 0
    step = step + 1
End If

I stepped through this, and it follows the logic. I think the problem with yours is that if what follows "then" is on the same line, it does not see it as a multiple criteria but only does the first IF. In fact I would have thought you'd get an error like End If without If block, or something like that

You're welcome! Please remember to mark the thread as solved?