I'm slowly learning VBA. I am doing this by watching youtube, reading this forum, reading books allegedly for "non programmers" etc. It's not optimal. But, it is the workable solution for my time and finances.
Can someone tell me what this means referring to sheet4? I know what vlookup is. But, this code works in the workbook and I cannot find the referenced sheet. I have unhidden all sheets. Obviously it has been renamed to something more english friendly. I suspect it is the Tech ID. Since the vlookup is only two columns and the fields appear to match. But, how do I definitivily see that sheet4 in VBA = Active_Techs (sheetname) in Excel proper?
Tid = Application.WorksheetFunction.VLookup(L_Name, Sheet4.Range("A1:B300"), 2, False)
Bookmarks