What is the worksheet name when vba and excel don't match up?

[Mr_Phil]

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?

Please Login or Register  to view this content.

[Trebor76]

Hi Mr_Phil,

It is the code name of the sheet.

If you open the Visual Basic Editor (VBE) i.e. where your macros are by pressing Alt + F8 (press and hold the Alt button then press F8) you'll see the workbook sheets listed in the the Project - VBAProject left-hand panel. The convention is the code name of each sheet followed by the sheet name used in the workbook which is put in brackets.

It's good practice to code using the code name as this allows for the sheet name in the workbook to be changed without effecting the functionality of the code to be interrupted.

HTH

Robert

[Mr_Phil]

Robert, I actually figured it out. Stare at one place long enough and the truth will out. But, your tip on best practice is every bit as valuable as your explanation. I wrote that one down three times so it is locked in. Thank you Sir!