How to use vlookup in excel 2000 vba code#
This is the old code for the vlookup that I use before and excel always ask for the unavailable sheet to be updated. This is the old code of the index match that I always ask the unavailable sheet from the formula. If Not ws.Name = MasterSheet.Name And Not ws.Name = DepSheet.Name Then
Here's the code I use but still found error on it sub lookup() How can I make Vlookup search all the available sheets in my workbook? The number of my sheets not always the same
0 kommentar(er)
