Can someone help me with ".find" without using select? I'm switching between multiple workbooks to get a summary of the data. How can I select the DT workbook, unprotect the sheet, and find the correct worker (from variable) and copy it? Then select the next workbook (where the summarized data goes) and paste the data?
VBA Code:
'Copies the DT hours and pastes in the Hours workbook
wkDT.Activate
Sheets("Labor").Unprotect
Sheets("Labor").Select
Range("B3").Activate
Cells.Find(What:=wrkr, After:=ActiveCell, LookIn:=xlValues, LookAt:=xlPart, searchorder:=xlByRows, MatchCase:=False).Activate
ActiveCell.Offset(32, 0).Select
Selection.Copy
'pastes the values into the new sheet
wK1.Activate
Sheets("Hours").Select
Cells(lastRow, 4).PasteSpecial xlPasteValues