Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert a macro into a formula?
I wish to write a formula that goes to the end value in a column and uses
that value for multiplying another cell. I am trying to multiply cell a7 by the last entry in the range c3:c20. I have the macro that goes to that entry but now need the steps to insert it into the formula. At the start of the month only cell c3 has data. On the second day c4 has data and so on. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert a macro into a formula?
=A7*LOOKUP(2,1/(C3:C20<""),C3:C20)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Obe" wrote in message ... I wish to write a formula that goes to the end value in a column and uses that value for multiplying another cell. I am trying to multiply cell a7 by the last entry in the range c3:c20. I have the macro that goes to that entry but now need the steps to insert it into the formula. At the start of the month only cell c3 has data. On the second day c4 has data and so on. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert a macro into a formula?
if all you want to do is always multply a number by the last entry in a range
you dont need a macro.... something like =A7*INDEX(C3:C20,COUNT(C3:c20)) -- paul remove nospam for email addy! "Obe" wrote: I wish to write a formula that goes to the end value in a column and uses that value for multiplying another cell. I am trying to multiply cell a7 by the last entry in the range c3:c20. I have the macro that goes to that entry but now need the steps to insert it into the formula. At the start of the month only cell c3 has data. On the second day c4 has data and so on. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert a macro into a formula?
=A7*INDIRECT("C"&COUNT(C3:C20)+2)
Regards, Stefi €žObe€ť ezt Ă*rta: I wish to write a formula that goes to the end value in a column and uses that value for multiplying another cell. I am trying to multiply cell a7 by the last entry in the range c3:c20. I have the macro that goes to that entry but now need the steps to insert it into the formula. At the start of the month only cell c3 has data. On the second day c4 has data and so on. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert a macro into a formula?
=A7*LOOKUP(9E+99,C:C)
Bob Phillips wrote: =A7*LOOKUP(2,1/(C3:C20<""),C3:C20) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Obe" wrote in message ... I wish to write a formula that goes to the end value in a column and uses that value for multiplying another cell. I am trying to multiply cell a7 by the last entry in the range c3:c20. I have the macro that goes to that entry but now need the steps to insert it into the formula. At the start of the month only cell c3 has data. On the second day c4 has data and so on. Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert a macro into a formula?
The answer to this question will also solve my problem so if there is a way
to place a macro into a formula please what is it? "Obe" wrote in message ... I wish to write a formula that goes to the end value in a column and uses that value for multiplying another cell. I am trying to multiply cell a7 by the last entry in the range c3:c20. I have the macro that goes to that entry but now need the steps to insert it into the formula. At the start of the month only cell c3 has data. On the second day c4 has data and so on. Thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert a macro into a formula?
If you create a UDF, it can be called directly from a worksheet formula.
For example Function myFunc(rng As Range) myFunc = rng.Cells.Count End Function and use like =IF(myFunc(A1:A10)1, "Y","N") these UDFs can only return a value, they cannot alter the worksheet/cells. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Swingstage" wrote in message ... The answer to this question will also solve my problem so if there is a way to place a macro into a formula please what is it? "Obe" wrote in message ... I wish to write a formula that goes to the end value in a column and uses that value for multiplying another cell. I am trying to multiply cell a7 by the last entry in the range c3:c20. I have the macro that goes to that entry but now need the steps to insert it into the formula. At the start of the month only cell c3 has data. On the second day c4 has data and so on. Thanks |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you insert a macro into a formula?
This is from Chip Pearson's site, specifically:
http://www.cpearson.com/excel/differen.htm " ... Generally, you cannot call a macro directly from a worksheet cell. For example, the following code does not work: =IF(A110,MyMacro). You can simulate the statement =IF(A110,MyMacro) by using the worksheet's Change event. Private Sub Worksheet_Change (ByVal Target As Excel.Range) If Target = [A1] Then If Target.Value 10 Then MyMacro End If End If End Sub ...." Hope this helps. Pete Swingstage wrote: The answer to this question will also solve my problem so if there is a way to place a macro into a formula please what is it? "Obe" wrote in message ... I wish to write a formula that goes to the end value in a column and uses that value for multiplying another cell. I am trying to multiply cell a7 by the last entry in the range c3:c20. I have the macro that goes to that entry but now need the steps to insert it into the formula. At the start of the month only cell c3 has data. On the second day c4 has data and so on. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a Formula with a Macro | Excel Discussion (Misc queries) | |||
Macro to insert formula | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Insert Line Macro | Excel Discussion (Misc queries) |