I have a column of data where after sorting the cells with no data is at the top of the column. I am using a vlookup to fill in these blank cells but I don't want the vlookup to fill in data beyond the last blank cell in that column. My macro currently just puts the vlookup in the first blank cell and I manually drag it down to the last blank cell. What VB would I use to add to this vlookup to have it stop at the last blank cell in the column?