+ Reply to Thread
Results 1 to 4 of 4

Convert macro from absolute to relative

  1. #1
    Registered User
    Join Date
    08-31-2014
    Location
    Israel
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Convert macro from absolute to relative

    Is there a easy way to convert a macro written when "Use relative references" was not pressed, to be a "relative" macro ?
    Best regards

  2. #2
    Forum Contributor lancer102rus's Avatar
    Join Date
    04-02-2014
    Location
    Ufa
    MS-Off Ver
    Excel 2010, 2013
    Posts
    252

    Re: Convert macro from absolute to relative

    Can we see part of you code written when "Use relative references" was not pressed?

  3. #3
    Registered User
    Join Date
    08-31-2014
    Location
    Israel
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Convert macro from absolute to relative

    Thank you,
    Actually since it was not a very long macro I recorded it again with the button pressed and deleted the previous macro with its code.
    However, since it happens quite many times that I (and I guess many other people) forget to press the button before starting to record, I am interested to know if there is some "conversion" feature in Excel.

  4. #4
    Forum Contributor lancer102rus's Avatar
    Join Date
    04-02-2014
    Location
    Ufa
    MS-Off Ver
    Excel 2010, 2013
    Posts
    252

    Re: Convert macro from absolute to relative

    If you speaking about formulas written by macros then there are 4 properties of the range:
    Formula Returns or sets a Variant value that represents the object's formula in A1-style notation and in the language of the macro.
    FormulaLocal Returns or sets the formula for the object, using A1-style references in the language of the user.
    FormulaR1C1 Returns or sets the formula for the object, using R1C1-style notation in the language of the macro
    FormulaR1C1Local Returns or sets the formula for the object, using R1C1-style notation in the language of the user

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Absolute references in relative ref macro
    By dillona27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2014, 10:11 PM
  2. How do i keep Column Absolute & make Row Relative in this Macro
    By DscvrnMyPotential in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2014, 12:00 AM
  3. VBA code to convert absolute to semi-relative referenced range
    By gpk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-29-2011, 07:40 AM
  4. [SOLVED] How to convert relative to absolute addressing instantly in Excel
    By loudun in forum Excel General
    Replies: 3
    Last Post: 11-24-2005, 01:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1