Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup thru many books
\\hi guys,
\\i have this piece of code to make vlookup work thru a work book. I'm trying to make it go thru different work books. let say i have 2 o 3 workbooks open, i wan to to be able to tell a cell: vlookallbooks(j2,c:h,2,false) and for it to look in that range of all open excel books. any suggestions ??? thnx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup thru many books
On Oct 8, 2:08 pm, Sangel wrote:
\\hi guys, \\i have this piece of code to make vlookup work thru a work book. I'm trying to make it go thru different work books. let say i have 2 o 3 workbooks open, i wan to to be able to tell a cell: vlookallbooks(j2,c:h,2,false) and for it to look in that range of all open excel books. any suggestions ??? thnx sorry i didnt inclide the code.. Function vlookallsheets(Look_Value As Variant, Tble_Array As Range, _ Col_num As Integer, Optional Range_look As Boolean) 'Use VLOOKUP to Look across ALL Worksheets and stops _ at the first match found. ''''''''''''''''''''''''''''''''''''''''''''''''' Dim wSheet As Worksheet Dim vFound On Error Resume Next For Each wSheet In ActiveWorkbook.Worksheets With wSheet Set Tble_Array = .Range(Tble_Array.Address) vFound = WorksheetFunction.VLookup _ (Look_Value, Tble_Array, _ Col_num, Range_look) End With If Not IsEmpty(vFound) Then Exit For Next wSheet Set Tble_Array = Nothing vlookallsheets = vFound End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
which books..? | New Users to Excel | |||
VBA-Books | Excel Programming | |||
Books | Excel Programming | |||
Books on VBA | Excel Programming | |||
Books | Excel Programming |