| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replace a function with its result or resulting reference in a formula?
Hello
How to replace a function with its result in a formula? For example, =INDEX(...)+INDEX(...) with =result_of_INDEX(a...)+result_of_INDEX(b...)=1025+ 1307. How to replace a function with its resulting reference in a formula? For example, =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to replace a function with its result or resulting reference in a formula?
I need to replace in 1000 cells automatically.
"Dmitry Kopnichev" сообщил/сообщила в новостях следующее: ... Hello How to replace a function with its result in a formula? For example, =INDEX(...)+INDEX(...) with =result_of_INDEX(a...)+result_of_INDEX(b...)=1025+ 1307. How to replace a function with its resulting reference in a formula? For example, =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to replace a function with its result or resulting reference in a formula?
A little macro
Sub ReplaceFormulae() Dim cell As Range Application.Calculation = xlCalculationManual For Each cell In ActiveSheet.UsedRange If cell.HasFormula Then cell.Value = "Result of " & cell.Formula & _ " = " & cell.text End If Next cell Application.Calculation = xlCalculationAutomatic End Sub -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... I need to replace in 1000 cells automatically. "Dmitry Kopnichev" сообщил/сообщила в новостях следующее: ... Hello How to replace a function with its result in a formula? For example, =INDEX(...)+INDEX(...) with =result_of_INDEX(a...)+result_of_INDEX(b...)=1025+ 1307. How to replace a function with its resulting reference in a formula? For example, =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to replace a function with its result or resulting reference in a formula?
The macro returns "Result or ==HLOOKUP(1...)+HLOOKUP(2...) = 365", but I
need =b11+z11. "Bob Phillips" сообщил/сообщила в новостях следующее: ... A little macro Sub ReplaceFormulae() Dim cell As Range Application.Calculation = xlCalculationManual For Each cell In ActiveSheet.UsedRange If cell.HasFormula Then cell.Value = "Result of " & cell.Formula & _ " = " & cell.text End If Next cell Application.Calculation = xlCalculationAutomatic End Sub -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... I need to replace in 1000 cells automatically. "Dmitry Kopnichev" сообщил/сообщила в новостях следующее: ... Hello How to replace a function with its result in a formula? For example, =INDEX(...)+INDEX(...) with =result_of_INDEX(a...)+result_of_INDEX(b...)=1025+ 1307. How to replace a function with its resulting reference in a formula? For example, =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. |
|
#5
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to replace a function with its result or resulting reference in a formula?
That is not what you said originally.
Where does B11 + Z11 come from? -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... The macro returns "Result or ==HLOOKUP(1...)+HLOOKUP(2...) = 365", but I need =b11+z11. "Bob Phillips" сообщил/сообщила в новостях следующее: ... A little macro Sub ReplaceFormulae() Dim cell As Range Application.Calculation = xlCalculationManual For Each cell In ActiveSheet.UsedRange If cell.HasFormula Then cell.Value = "Result of " & cell.Formula & _ " = " & cell.text End If Next cell Application.Calculation = xlCalculationAutomatic End Sub -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... I need to replace in 1000 cells automatically. "Dmitry Kopnichev" сообщил/сообщила в новостях следующее: ... Hello How to replace a function with its result in a formula? For example, =INDEX(...)+INDEX(...) with =result_of_INDEX(a...)+result_of_INDEX(b...)=1025+ 1307. How to replace a function with its resulting reference in a formula? For example, =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. |
|
#6
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to replace a function with its result or resulting reference in a formula?
The B11 is the cell from which the HLOOKUP(1...) returns value. The Z11 is
the cell from which the HLOOKUP(2...) returns value. "Bob Phillips" сообщил/сообщила в новостях следующее: ... That is not what you said originally. Where does B11 + Z11 come from? -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... The macro returns "Result or ==HLOOKUP(1...)+HLOOKUP(2...) = 365", but I need =b11+z11. "Bob Phillips" сообщил/сообщила в новостях следующее: ... A little macro Sub ReplaceFormulae() Dim cell As Range Application.Calculation = xlCalculationManual For Each cell In ActiveSheet.UsedRange If cell.HasFormula Then cell.Value = "Result of " & cell.Formula & _ " = " & cell.text End If Next cell Application.Calculation = xlCalculationAutomatic End Sub -- HTH Bob Phillips "Dmitry Kopnichev" wrote in message ... I need to replace in 1000 cells automatically. "Dmitry Kopnichev" сообщил/сообщила в новостях следующее: ... Hello How to replace a function with its result in a formula? For example, =INDEX(...)+INDEX(...) with =result_of_INDEX(a...)+result_of_INDEX(b...)=1025+ 1307. How to replace a function with its resulting reference in a formula? For example, =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| large function result as reference for offset function | Excel Discussion (Misc queries) | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Find the Cell Reference Resulting from MAX function | Excel Worksheet Functions | |||
| How to replace a function with its resulting reference in a formula? | Excel Worksheet Functions | |||
| How to replace a function with its result or resulting reference in a formula? | Excel Worksheet Functions | |||
Hybrid Mode
