Macro Command to Select Records in an Excel Database

ID: Q70791

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
Microsoft Excel for OS/2, versions 2.2, 3.0
Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0, 4.0, 5.0

SUMMARY

It is often necessary to select all the records in a database. If you select the area with the defined name, DATABASE, all the records plus the field names will be selected.

The following macro command will offset from the name of DATABASE to select just the records:


   =SELECT(OFFSET(!database,1,0,ROWS(!database)-1,COLUMNS(!database)))

REFERENCES

"Online Help," version 5.0
"Function Reference," version 4.0, pages 299-300, 387-379
"Function Reference," version 3.0, pages 163-164, 209-210
"Functions and Macros," version 2.1x, pages 320, 348

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.50 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 5.0


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 21, 1999