Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change the reference type of multiple formulas
Can I change the cell reference type (absolute, relative etc.) for multiple
cells without manually adjusting each cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change the reference type of multiple formulas
By macro. Choose which type from the 4 below.
Sub Absolute_Both() Dim cell As Range For Each cell In Selection If cell.HasFormula Then cell.Formula = Application.ConvertFormula _ (cell.Formula, xlA1, xlA1, xlAbsolute) End If Next End Sub Sub AbsoluteRow() Dim cell As Range For Each cell In Selection If cell.HasFormula Then cell.Formula = Application.ConvertFormula _ (cell.Formula, xlA1, xlA1, xlAbsRowRelColumn) Next End Sub Sub AbsoluteCol() Dim cell As Range For Each cell In Selection If cell.HasFormula Then cell.Formula = Application.ConvertFormula _ (cell.Formula, xlA1, xlA1, xlRelRowAbsColumn) Next End Sub Sub Relative() Dim cell As Range For Each cell In Selection If cell.HasFormula Then cell.Formula = Application.ConvertFormula _ (cell.Formula, xlA1, xlA1, xlRelative) Next End Sub Gord Dibben MS Excel MVP On Wed, 19 Mar 2008 09:15:01 -0700, Derfel wrote: Can I change the cell reference type (absolute, relative etc.) for multiple cells without manually adjusting each cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional change of column reference in formulas | Excel Discussion (Misc queries) | |||
Update reference in multiple formulas | Excel Worksheet Functions | |||
How to change cell reference within formulas | Excel Worksheet Functions | |||
transferring formulas with absolute reference to multiple tabs | Excel Discussion (Misc queries) | |||
how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) |