• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Recording Macros > Using Absolute and Relative References

Using Absolute and Relative References

In the CompanyAddress macro, Excel recorded references as absolute references in the A1 format (as opposed to the R1C1 format). As a result, the CompanyAddress macro always enters the company name in A6 and the address in A7 and A8.

In VBA, cell selections are recorded as absolute references unless you click the Relative Reference button on the Stop Recording toolbar. If you click this button, the recorder begins recording relative references. If you click the button again, the recorder records subsequent actions using absolute references—and so on. You can toggle between relative and absolute references at any time while recording.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint