First off, I'd like to say thank you to everyone who has been so helpful. i really am learning alot from this message board. Now on to my question.. The first part of my macro is....I have to do a vlookup in column B and I a referencing column A. My question is...I never know how long my data set will be in column A, so i drag my formula down to line B10000 in my macro to ensure that I never miss anything. is there a way that I could do a count of column A an then drag my formula down only as far as I need it to go?