Hi there ,

I just encountered a strange thing.
When using the following code , the code selects the next cell ( in this case H2) instead of the next filtered visible cell.( it should be H693)

    Range("H1").Select
    Do
        ActiveCell.Offset(1, 0).Select
        ActiveCell.Offset(0, 41).Value = 1346.9
        Do
            ActiveCell.Offset(1, 0).Select
        Loop Until ActiveCell.Offset(1, 9).Value <> ActiveCell.Offset(0, 9).Value
    Loop Until ActiveCell.Value = ""
I filtered my worksheet with criteria in 2 columns , and need to loop through the filtered lines to update some cells.

Can someone tell me what i did wrong ?

Kind regards
Mario