| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba for lookup and autofill
Hi all, I'm creatinf a vlookup from a column in one shhet to a column in
another, I then want to autofill to the end of the column automatically . Can anyone help. Thanks a lot. -- delmac |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba for lookup and autofill
You don't give many details, but this sets up a typical formula in B1, and
copies down 100 rows With Range("B1") .FormulaR1C1 = "=VLOOKUP(RC[-7],Sheet2!RC[-2]:R[13]C[4],2,FALSE)" .AutoFill Range("B1").Resize(100) End With -- HTH Bob Phillips "delmac" wrote in message ... Hi all, I'm creatinf a vlookup from a column in one shhet to a column in another, I then want to autofill to the end of the column automatically . Can anyone help. Thanks a lot. -- delmac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I isolate a lookup vectors but not values from autofill? | Excel Worksheet Functions | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
| Autofill | Excel Worksheet Functions | |||
| Q. Autofill question: Can I autofill alpha characters like I can numbers? | Excel Programming | |||
| Autofill & Lookup Function | Excel Programming | |||
Linear Mode
