Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
visual basic example of the defunct "Extract" function in Excel 4.
Could anyone provide me with Visual Basic example of how to replace the
Extract function that was built into Excel 4.0 that no longer exists since version '97. The Extract function was found in the Data menu of 4.0 and it was used to extract a row of data out of a database based on matching criteria such as a code number. It would be something like a Vlookup to match a cell in a column and when found the entire row gets copied to another row that can be referenced by other formulas. I'd really appreciate any help I can get on this. I have a spreadsheet at work that I am trying to re-write and Microsoft's decision to eliminate this simple yet powerful command is causing me great stress! Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic "Blinking" Cursor??? | Excel Discussion (Misc queries) | |||
Excel crashes on "Close" Visual Basic error 400 | Excel Discussion (Misc queries) | |||
"Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
Registry key for "Trust access to Visual Basic project" | Excel Programming | |||
How to set equivalent of Visual Basic "redraw = false" | Excel Programming |