I want to use vlookup in a column and then autofill that column after entering the formula in the first cell of the column. I need the autofill to ONLY fill in the blank cells in the column as there is data in the bottom of the column already.
I want to use this in a current macro I am using. Currently I have the macro only create the vlookup formula and enter the data in the first cell. I then manually drag the formula down to the last blank cell in the column. I want to use a vba to have it fill in the rest of the blank cells.
How can this be done or can it be done?

Mike

Without seeing the macro you're currently using for this, plus a workbook with some representative data, it's a bit much to expect anyone to provide the code you want for this.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]