Thread: create a macro with the match lookup_array is changing everyday
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
  
Posts: 2,510
Default create a macro with the match lookup_array is changing everyday
When you record your macro, instead of selecting C1:C10, Click the column Id
at the top of the column to select the entire column for the Lookup_Array.

--
Regards,

OssieMac


"Asraf" wrote:

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 QuoteReply With Quote