I have a macro for comparing two columns using MATCH, IF,ISNA - TopicsExpress

I have a macro for comparing two columns using MATCH, IF,ISNA functions .I have to run this macro for many workbooks of which no.of entries in columns may vary from files to files. So I put common range from 2 to 20000. Can I set a range from 2 to the last data cell of each columns? Range(Q2).Select ActiveCell.FormulaR1C1 = =MATCH(RC[-16],C[-9],0) Range(Q2).Select Selection.AutoFill Destination:=Range(Q2:Q20000), Type:=xlFillDefault Range(Q2:Q20000).Select Range(D2).Select ActiveCell.FormulaR1C1 = =IF(ISNA(RC[13]),MISSING,MATCHED) Range(D2).Select Selection.AutoFill Destination:=Range(D2:D20000), Type:=xlFillDefault Range(D2:D20000).Select

PRESS RELEASE (Hows this??) On May 18th Celoron Legion will

BREAKING NEWS!!!!!!!!!!! Nigerian Forces have rescued Chibok

REPOST: Maraming nagtatanong at nagpapaturo kung paano kumita

PROMOSI 1KOTAK RM105 FREE POSTAGE SEMENANJUNG :) 10 manfaat hebat

Never allow the disappointment to stop you from finishing strong

Bear with us tote bag - (In house design), moon bear inspired, by

What Is Brain Abundance?? ---------------------- => The Most

Harry Potter thing you only can know from interviews... -Teddy

Cookies and Cream Candy Bars (these are amazing) Always SHARE