Is there a easy way to convert a macro written when "Use relative references" was not pressed, to be a "relative" macro ?
Best regards
Is there a easy way to convert a macro written when "Use relative references" was not pressed, to be a "relative" macro ?
Best regards
Can we see part of you code written when "Use relative references" was not pressed?
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks