Microsoft KB Archive/86794

{| = Application Note on Cell Referencing From a Macro =
 * width="100%"|

Last reviewed: October 7, 1997

Article ID: Q86794 3.00 WINDOWS kbother The information in this article applies to:


 * Microsoft Excel for Windows, version 3.0

SUMMARY
Microsoft Excel has a powerful macro language that allows you to automate frequently performed tasks, customize functions, or create interactive applications. Cell referencing is an essential element in Microsoft Excel's macro language. To write a successful macro, you must understand the different ways to reference a cell. Macro commands take either relative or absolute references with respect to a cell, a range of cells, or defined ranges on either a worksheet or a macro sheet. In a macro, there are a variety of ways to refer to a cell, depending on whether the cell you are referring to is on a macro sheet or a worksheet and depending on which sheet is active when the macro command is executed.

MORE INFORMATION
To obtain this application note, WE0125, &quot;Cell Referencing From a Macro,&quot; call Microsoft Product Support Services at (425) 635-7070.

This application note is also available in the Software/Data Library and can be found by searching on the word WE0125, the Q number of this article, or S13553. WE0125 was archived using the PKWARE file-compression utility.
 * }