Make all formula references absolute

Topic

New Reply

Hi,

Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

Any help will be appreciated.

TX

Reply | Quote

Replies

Hi,

Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

Any help will be appreciated.

TX

Reply | Quote

Hi,

Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

Any help will be appreciated.

TX

Reply | Quote

Hi,

Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

Any help will be appreciated.

TX

Reply | Quote

Hi,

Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

Any help will be appreciated.

TX

Reply | Quote

Hi,

Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

Any help will be appreciated.

TX

Reply | Quote

Hi,

Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

Any help will be appreciated.

TX

Reply | Quote

Hi,

Is there a way to convert references in selected formulas/functions on a spreadsheet from relative refs to absolute refs? F4 works to cycle through the ref styles, but only for the active cell. I want to select multiple formulas and have all the refs in the formula convert to absolute.

Any help will be appreciated.

TX

Reply | Quote

Hi Rudi,

Get yourself the free ASAP Utilities (http://www.asap-utilities.com/download-asap-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

Regards, Teunis

Reply | Quote

Hi Rudi,

Get yourself the free ASAP Utilities (http://www.asap-utilities.com/download-asap-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

Regards, Teunis

Reply | Quote

Hi Rudi,

Get yourself the free ASAP Utilities (http://www.asap-utilities.com/download-asap-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

Regards, Teunis

Reply | Quote

Hi Rudi,

Get yourself the free ASAP Utilities (http://www.asap-utilities.com/download-asap-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

Regards, Teunis

Reply | Quote

Hi Rudi,

Get yourself the free ASAP Utilities (http://www.asap-utilities.com/download-asap-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

Regards, Teunis

Reply | Quote

Hi Rudi,

Get yourself the free ASAP Utilities (http://www.asap-utilities.com/download-asap-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

Regards, Teunis

Reply | Quote

Hi Rudi,

Get yourself the free ASAP Utilities (http://www.asap-utilities.com/download-asap-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

Regards, Teunis

Reply | Quote

Hi Rudi,

Get yourself the free ASAP Utilities (http://www.asap-utilities.com/download-asap-utilities.php). Under Formulas there is the utility to change the reference mode for a selected number of cells containing formulas.

Regards, Teunis

Reply | Quote

You can also use this macro:

Code:

Sub Convert2Absolute()
    Dim oCell As Range
    If TypeName(Selection) = "Range" Then
        For Each oCell In Selection
            oCell.Formula = Application.ConvertFormula(oCell.Formula, xlA1, xlA1, True)
        Next
    End If
End Sub

Reply | Quote

You can also use this macro:

Code:

Sub Convert2Absolute()
    Dim oCell As Range
    If TypeName(Selection) = "Range" Then
        For Each oCell In Selection
            oCell.Formula = Application.ConvertFormula(oCell.Formula, xlA1, xlA1, True)
        Next
    End If
End Sub

Reply | Quote

You can also use this macro:

Code:

Sub Convert2Absolute()
    Dim oCell As Range
    If TypeName(Selection) = "Range" Then
        For Each oCell In Selection
            oCell.Formula = Application.ConvertFormula(oCell.Formula, xlA1, xlA1, True)
        Next
    End If
End Sub

Reply | Quote

You can also use this macro:

Code:

Sub Convert2Absolute()
    Dim oCell As Range
    If TypeName(Selection) = "Range" Then
        For Each oCell In Selection
            oCell.Formula = Application.ConvertFormula(oCell.Formula, xlA1, xlA1, True)
        Next
    End If
End Sub

Reply | Quote

You can also use this macro:

Code:

Sub Convert2Absolute()
    Dim oCell As Range
    If TypeName(Selection) = "Range" Then
        For Each oCell In Selection
            oCell.Formula = Application.ConvertFormula(oCell.Formula, xlA1, xlA1, True)
        Next
    End If
End Sub

Reply | Quote

You can also use this macro:

Code:

Sub Convert2Absolute()
    Dim oCell As Range
    If TypeName(Selection) = "Range" Then
        For Each oCell In Selection
            oCell.Formula = Application.ConvertFormula(oCell.Formula, xlA1, xlA1, True)
        Next
    End If
End Sub

Reply | Quote

You can also use this macro:

Code:

Sub Convert2Absolute()
    Dim oCell As Range
    If TypeName(Selection) = "Range" Then
        For Each oCell In Selection
            oCell.Formula = Application.ConvertFormula(oCell.Formula, xlA1, xlA1, True)
        Next
    End If
End Sub

Reply | Quote

You can also use this macro:

Code:

Sub Convert2Absolute()
    Dim oCell As Range
    If TypeName(Selection) = "Range" Then
        For Each oCell In Selection
            oCell.Formula = Application.ConvertFormula(oCell.Formula, xlA1, xlA1, True)
        Next
    End If
End Sub

Reply | Quote

Thanks guys.
Appreciate the replies.

Teunis: I queried this not for me, but for a client I am dealing with. I’ll tell them about ASAP. (I have it, and its a great utility)
Jan Karel: Cheers for that macro. This is great!

Reply | Quote

Thanks guys.
Appreciate the replies.

Teunis: I queried this not for me, but for a client I am dealing with. I’ll tell them about ASAP. (I have it, and its a great utility)
Jan Karel: Cheers for that macro. This is great!

Reply | Quote

Thanks guys.
Appreciate the replies.

Teunis: I queried this not for me, but for a client I am dealing with. I’ll tell them about ASAP. (I have it, and its a great utility)
Jan Karel: Cheers for that macro. This is great!

Reply | Quote

Thanks guys.
Appreciate the replies.

Teunis: I queried this not for me, but for a client I am dealing with. I’ll tell them about ASAP. (I have it, and its a great utility)
Jan Karel: Cheers for that macro. This is great!

Reply | Quote

Thanks guys.
Appreciate the replies.

Teunis: I queried this not for me, but for a client I am dealing with. I’ll tell them about ASAP. (I have it, and its a great utility)
Jan Karel: Cheers for that macro. This is great!

Reply | Quote

Thanks guys.
Appreciate the replies.

Teunis: I queried this not for me, but for a client I am dealing with. I’ll tell them about ASAP. (I have it, and its a great utility)
Jan Karel: Cheers for that macro. This is great!

Reply | Quote

Thanks guys.
Appreciate the replies.

Teunis: I queried this not for me, but for a client I am dealing with. I’ll tell them about ASAP. (I have it, and its a great utility)
Jan Karel: Cheers for that macro. This is great!

Reply | Quote

Thanks guys.
Appreciate the replies.

Teunis: I queried this not for me, but for a client I am dealing with. I’ll tell them about ASAP. (I have it, and its a great utility)
Jan Karel: Cheers for that macro. This is great!

Reply | Quote