Posted to microsoft.public.excel.programming
|
|
create a macro with the match lookup_array is changing everyday
Use a Dynamic Named Range
http://www.ozgrid.com/Excel/DynamicRanges.htm
--
Regards
Dave Hawley
www.ozgrid.com
"Asraf" wrote in message
...
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
|