Hi, Can someone show me how to loop this bit of code I am using. I've got a workbook to track staff hours for up to 12 staff. The code I'm using below seems like it will do the trick, but I was sure hoping there was some way to shorten it with a loop.

Please Login or Register  to view this content.
I posted just the code for just the first 2 staff. There are 12 staff slots in all, each Label is named the same with a different number on the end, ie LBLName2 is for staff 2, LBLName3 is for staff 3. Also the sheet rows will all increment by 1 as well. Can anyone help me to figure this out. Thanks guys