Frncis
Member
I am trying find the next empty cell in Column B. When the code below is run it provides this error, "Rum time error 1004; Application-defined or object defined error".
B6 has text, but is locked. I have tried to figure out what I am doing wrong, but have not been successful. Am i correct in thinking that this line
Code:
Private Sub Worksheet_Activate()
Range("B7").End(xlDown).Offset(2, 0).Select
End Sub
Range("B7").End(xlDown).Offset(2, 0).Select
, tells it to go to B7 & then go down to the next empty one.