Hi all,

Can anyone tell me why the following code fails?
I can't see a problem with it, but it just won't run as part of a userform_initialize code.
I want to check the worksheet "Model", and if a cell in column A is greater than 0 and corresponding cell in Column B is empty/blank/"", then column C should be updated to empty/blank/""
Any help much appreciated

Pete

        Dim LastRow As Long, cell As Range
        ActiveSheet = Sheets("Model")
        With Sheets("Model")
               LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row
              For Each cell In Range("A2:A" & LastRow)
                     If cell.Offset(0, 1).Value = "" Then cell.Offset(0, 2).Value = ""
            Next
        End With