Hi,
I saw this formula
in a sheet that was given to me and i am trying to figure out where is this "Excel Functions" sheet.
I unhide all sheets , until the unhide sheet is grayed out. however I see it in VB code window as Sheet61(Excel Functions)
i even ran this code : although the fact that the file name is .xlsx indicate there is no macro or vba
I saw this formula
Code:
=VLOOKUP('1 Project Info & Instructions'!$G$25,'Excel Functions'!$D$4:$E$7,2,FALSE)
I unhide all sheets , until the unhide sheet is grayed out. however I see it in VB code window as Sheet61(Excel Functions)
i even ran this code : although the fact that the file name is .xlsx indicate there is no macro or vba
Code:
Sub ShowNames()
Dim xName As Name
For Each xName In Application.ActiveWorkbook.Names
xName.Visible = False
Next
End Sub