Extracted Values Not Highlighted After Data ExtractLast reviewed: November 2, 1994Article ID: Q69671 |
SUMMARYWhen you choose Extract from the Data menu using an extract range that is defined as the name "Extract", Excel will not select the extracted area after extracting. If no extract range name is defined, Excel selects the range names and the data that was extracted. This allows you to extract without selecting the titles of the fields that you want to extract.
MORE INFORMATIONA four-line macro can be recorded to select the extracted range and titles after using a defined name as the extract range, as follows:
A1: =EXTRACT?() A2: =SELECT("Extract") A3: =SEND.KEYS("^+{Down}") A4: =RETURN()This macro assumes that the defined name is "Extract". It performs the extract and then selects your extract range.
REFERENCES"Microsoft Excel User's Guide." Version 3.00, page 380-384.
|
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |