Application Note on Cell Referencing From a Macro

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, "Cell Referencing From a Macro," 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.