Thread
:
create a macro with the match lookup_array is changing everyday
View Single Post
#
1
Posted to microsoft.public.excel.programming
Asraf
external usenet poster
Posts: 10
create a macro with the match lookup_array is changing everyday
Dear all,
I have a problem to create a macro bcos my data for lookup_array will be add
up everyday.
Sub Macro1()
ActiveCell.FormulaR1C1 = "=MATCH(RC[1],R1C[2]:R10C[2],0)"
End Sub
Reply With Quote
Asraf
View Public Profile
Find all posts by Asraf