Microsoft KB Archive/69671

{| = Extracted Values Not Highlighted After Data Extract =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q69671

SUMMARY
When you choose Extract from the Data menu using an extract range that is defined as the name &quot;Extract&quot;, 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 INFORMATION
A 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(&quot;Extract&quot;) A3: =SEND.KEYS(&quot;^+{Down}&quot;) A4: =RETURN This macro assumes that the defined name is &quot;Extract&quot;. It performs the extract and then selects your extract range.