When you get the error and the line is highlighted, you can hover the
mouse cursor over a variable and Excel will show you the value of that
variable as of the time the error occurred. What values do you see for
txtHrs2.Text and txtHrs2.Value ?