loop through column

[neveu]

hi,

i would need to loop through a column and see if there are data in the cells as follows:

to go to range E5:F5 and count if there is information in the range
then do the same thing for range E5:F5,
E5:G5
E5:H5
E5:I5 and so on up to
E5:BB5


can you please help me. i have no idea how to loop through letters.

thank you

 

[dsaffo]

Hello.

You can loop through columns as a number. You can look in a cell by the following:

Dim i as Long
Dim iCounter as Long

For i = 5 to 10
    If ActiveWorksheet.Cells(5,i) <> "" Then
        iCounter = iCounter + 1
    End If
Next i

This will loop through row 5 of columns E through J.

Hope that helps.