Private Sub CmdOK_Click()
ActiveWorkbook.Sheets("Active Employees").Activate
Range("A2").Select
Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If
The above is the code that I have for my "ok" button.
I have created an employee spreadsheet using a userform. The userform puts the information on my "Active Employees" worksheet. The spreadsheet has around 33 columns. Each row is an employee record containing all of their information. Because of the high "turn around" we have w/ employees, once I enter a date into my "release date" column, that row (or record) gets moved from my "Active Employees" worksheet to my "Inactive Employees" worksheet.
I hope this added info helps.