Insert New Employee

**TimlmiT** · 02-15-2018, 06:54 PM

Mumps!,

I am trying to learn as I go...
Can you provide a quick explanation of what the (- 2) and (-3) are doing in this code?

 Rows(Findrow.Row - 2).Insert
    Range("A" & Findrow.Row - 3) = sNumber

Also, If I enter Abe Abraham as a new employee, his row is inserted after Greg Clem.

**Mumps1** · 02-16-2018, 09:59 AM

Try the attached file. I have fixed the alphabetizing problem. "Findrow.row" is a variable that represents the row number of the cell containing "Total Hours". The (- 2) and (-3) subtract 2 and 3 respectively from the row number containing "Total Hours". For example, if Findrow.row=20 then subtracting 3 will change its value to 17 which is the value I need because it refers to the row number of the last name in column B. I hope this makes sense.