| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vLookUp. Works Manually but not by code.
I am using Excel 97.
This is how the macro works. I have a list of account numbers. To make the spreadsheet easy to read. I have a "database" of account numbers in column A and the company names in column B. The macro sorts the "database" in column A, then proceeds to retrieve the value in column B. For whatever reason, the vLookUp misses some values. But if I do it manually, it works. Has anyone seen a problem like this? Thanking you in advance Rich |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vLookUp. Works Manually but not by code.
Hi
you may post the code you have used -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ups.com... I am using Excel 97. This is how the macro works. I have a list of account numbers. To make the spreadsheet easy to read. I have a "database" of account numbers in column A and the company names in column B. The macro sorts the "database" in column A, then proceeds to retrieve the value in column B. For whatever reason, the vLookUp misses some values. But if I do it manually, it works. Has anyone seen a problem like this? Thanking you in advance Rich |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup not finding values unless lookup value is manually entered | Excel Worksheet Functions | |||
| VLOOKUP only works on data manually entered. | Excel Discussion (Misc queries) | |||
| manually specifing a range in the code below | Excel Programming | |||
| Why won't this code works | Excel Programming | |||
| VBA Code Works in 97, Not in 2002 | Excel Programming | |||
Hybrid Mode
