| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup Variables
I download a new spreadsheet everyday, this spreadsheet will have several new
rows everytime. I run a macro What I need is for this lookup to automatically find the last row in the table array Range("H2").Select ActiveCell.FormulaR1C1 = _ "=VLOOKUP(RC[8],'[Cell Refs Update Macro V3.xls]Lookup'!R2C1:R1770C5,3,FALSE)" Selection.AutoFill Destination:=Range("H2:H" & lastrow) Can anybody help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup & 2 variables | Excel Worksheet Functions | |||
| VLOOKUP - TWO Variables | Excel Discussion (Misc queries) | |||
| VLOOKUP - Two Variables | Excel Discussion (Misc queries) | |||
| using VLookup with two variables to get results | Excel Discussion (Misc queries) | |||
| vlookup Variables | Excel Worksheet Functions | |||
Threaded Mode
