Thread
:
How do you insert a macro into a formula?
View Single Post
#
3
Posted to microsoft.public.excel.misc
paul
external usenet poster
Posts: 247
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
Reply With Quote
paul
View Public Profile
Find all posts by paul