| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternatives to "WorksheetFunction.VLookup"
Hi
I have a sub which uses a For...Next loop to populate the cells in a column.based on the contents of column A in the same row. I presently use WorksheetFunction.VLookup to get the value from another worksheet. Is there a faster way to achieve the same result, maybe without calling a worksheet function? The code takes some time to run through about 400 cells. I have auto calculation turned off during execution. TIA Damien |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| "Unable to get the VLookup property of the WorksheetFunction class | Excel Discussion (Misc queries) | |||
| How to turn on the pop-up "alternatives" while editing in the VBA Editor | Excel Programming | |||
| Errortrap for WorksheetFunction.CountA - "No cells were found"? | Excel Programming | |||
| IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE") | Excel Programming | |||
![Damien McBain[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
