Microsoft KB Archive/130621

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

=
=========================================================

= 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.

  From the Tools menu, choose Macro. Select Macros On.   From the Tools menu, choose Macro. Select Start Recording.   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.   From the Edit menu, choose Find.   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.   Click OK. The range you specified is now selected.   Record the rest of your macro, using keystrokes instead of mouse movements whenever possible.   From the Tools menu, choose Macro. Select Stop Recording. </li>  Click Stop. </li></ol>

= 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.