create a macro with the match lookup_array is changing everyday

A

Asraf

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
 
J

Jacob Skaria

Try
ActiveCell.FormulaR1C1 = "=MATCH(RC[1],C[2],0)"

OR

Dim lngRow As Long
lngRow = Cells(Rows.Count, ActiveCell.Offset(, 2).Column).End(xlUp).Row
ActiveCell.FormulaR1C1 = "=MATCH(RC[1],R1C[2]:R" & lngRow & "C[2],0)"
 
O

OssieMac

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro match function problem 12
why won't this work 2
MATCH function, with variable lookup_array 12
"=TEXT(RC[-1],"MMM")" 4
Data samples 3
macro to copy rows that contain a cell with a certain number 2
File Name changes with dates and Deleting Rows of Zeros 0
pivot table macro with a filtering variable 3

Top