Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Urgent - Help VBA Macro
Hello,
I have the following VBA Macro. But I'm getting an error msg on the Set Lookup_Table_VBAK = ("A1:EZ65000").range Can any one help? Sub Macro1() Dim VBAK As Variant Dim Lookup_Table_VBAK As Range VBAK = Application.GetOpenFilename If VBAK = False Then Exit Sub 'User cancelled Workbooks.Open Filename:=VBAK Set Lookup_Table_VBAK = ("A1:EZ65000").range Windows("Billable Jobs Tierney Total Validation.xls").Activate Sheets("Header-Sales").Select Range("D3").Value = Application.VLookup("C:C", Lookup_Table_VBAK, 2, 0) -- Regards, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
URGENT Mac/PC macro compatibility problem | Excel Discussion (Misc queries) |