nextrow.value

I am receiving a runtime error 91 for the following code. It occurs at the newrow = Nme.Range("L4:L70").Find(newnme).Row line. Private Sub Cmd_Add_Click() Dim nextrow As Integer Dim newnme, nxtnme As String Dim newrow, wkrow As Range Dim rw, n As Integer Set Wkly = Sheets("Weekly") Set Nme =...

I'm trying to copy data across to another sheet if a condition is met. The condition is the value 'Unresolved' in column K - this is what I have so far; Nextrow = Sheet14.Range("A65536").End(xlUp).Row + 1 For Each cell In Sheet7.Range("A2:A" & LastRow) If cell.Offset(0, 10).Value =...

I have a UserForm that has 43 text and combo boxes. I want to introduce some code that verifies that certain fields are completed, and in certain formats. An example is "txt_Updated". This field is required to be completed. I added the code below, but want the User to be able to either enter...