![]() Those non operable code statements can be deleted. ![]() '.Value = WorksheetFunction.Text(sttime, "hh:mm") & Chr(10) & myRole & Chr(10) & myJob & Chr(10) & WorksheetFunction.Text(fttarget, "hh:mm") Value = WorksheetFunction.Text(sttime, "hh:mm") & Chr(10) & myRole & Chr(10) & myJob & Chr(10) & WorksheetFunction.Text(fttarget, "hh:mm") Range(cfind1, cfind2).Offset(0, 1).Select 'Range(ActiveCell, ActiveCell.Offset(-4, 0)).Merge Set cfind2 = Range(Range("A4"), Range("a4").End(xlDown)).Find(what:=fttime, lookat:=xlWhole) Set cfind1 = Range(Range("A4"), Range("a4").End(xlDown)).Find(what:=sttime, lookat:=xlWhole) Sttarget = InputBox("Start Time (Must be 24hr time with Colon eg 01:30, 12:15, 23:45.)")įttarget = InputBox("Finishing Time (Must be 24hr time with Colon eg 01:30, 12:15, 23:45.)")
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |