Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically run a macro everyday | Excel Discussion (Misc queries) | |||
MATCH function, with variable lookup_array | Excel Programming | |||
Match with Complex Lookup_array | Excel Worksheet Functions | |||
Macro to run everyday??? | Excel Programming | |||
any auto formula changing 1 - 31st everyday & multiply $975 | Excel Discussion (Misc queries) |