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
Bookmarks