Mac Works: How to Select a Range of Cells When Using a Macro
  
PSS ID Number: Q130621
Article last modified on 10-22-1998
 
2.0x 3.0x 4.0 4.0a 4.0b
 
MACINTOSH
 

======================================================================
 
---------------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 2.0, 3.0, 4.0, 4.0a, and
   4.0b
---------------------------------------------------------------------------
 
SUMMARY
=======
 
When you create a macro to select a range of cells in a Spreadsheet
document, you can take steps to make sure the same range of cells is
selected every time.
 
MORE INFORMATION
================
 
NOTE: The following steps are written for versions of Works 4.0. Microsoft
Works versions 3.x and 2.x do not use the Tools menu to access Macro
information. For those versions substitute the following menu for Tools:
 
   Works 3.x, use Window.
 
   Works 2.x, use Macro.
 
Use the following steps to ensure that the same range of cells is
selected every time.
 
1. From the Tools menu, choose Macro. Select Macros On.
 
2. From the Tools menu, choose Macro. Select Start Recording.
 
3. In the Start Recording dialog box, type a key to use with the Option key
   to start the macro. Type a description for the macro. Click OK.
 
4. From the Edit menu, choose Find.
 
5. Enter the cell range you want the macro to select. For example, to
   select a range of cells from cell A1 to F10, type the following
 
      A1:F10.
 
6. Click OK. The range you specified is now selected.
 
7. Record the rest of your macro, using keystrokes instead of mouse
   movements whenever possible.
 
8. From the Tools menu, choose Macro. Select Stop Recording.
 
9. Click Stop.
 
MORE INFORMATION
================
 
Because mouse movements are recorded without an absolute reference to a
particular cell, using them to select ranges of cells can be unpredictable.
 
The Find dialog box requires a precise range of cells to allow the macro to
always select exactly the same range of cells. For this reason, mouse
movements should be avoided while you record macros. Use keystrokes and
menu selections whenever possible.
 
Additional query words: kbhowto 2.0x 3.0x 4.00 4.00a 4.00b mac m_works
======================================================================
Version           : 2.0x 3.0x 4.0 4.0a 4.0b
Platform          : MACINTOSH
Issue type        : kbhowto
=============================================================================
Copyright Microsoft Corporation 1998.