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

Buddha Turns the Kabbalah Wheel: Jewish Buddhist Resonance from a

Would like to say a huge huge thank you to everyone who came to

Saturday, November 29 The city [Jerusalem] will actually be

best workout plan for weight loss

I wish I could be as forgiving as a dog...Almost 2 years ago,

James Edward Harden, Jr. a Franchise Player! It was believed

This is my mind. When I dont care, my mind will dreaming. When I

His Holiness Pope Twadharos second Wednesday October 23, 2013

Niet vergeten! Morgen bij Bakkerij Okoro: Gewijde mastellen, mét

Today News Headlines • Boko Haram suicide mission: Military

34 years ago tomorrow , 2 kids said I do:) yes we have had great

weekly weight loss meal plan

O Allah, forgive our living, our dead, our young, our old, our

Menko Perekonomian Hatta Rajasa, Menteri ESDM Jero Wacik, Menteri

Lumbar Transforaminal Epidural Steroid Injection

FALSE DOCTRINE LEADERS B C D E F G H I J K L M N O P R S T U V W

CNY / URGENT CASHIERS / NO EXPERIENCE / TRAINING PROVIDED / NO

My trip to Syracuse was short yet productive. I found a great

Trying Harder is the solution from MoonDog Radio

OTIMISMO FAZ BEM Temos motivos para sermos otimistas? Claro que

IRISH MUSIC & COMEDY TODAY If you like Irish Music, or need some