Vlookup fill down blank cells in column

NoSparks · #6 09-23-2016, 04:54 PM

Assuming what you have works, you already have an autofill for column "D" that fills to row 8000.
I guess your question is what to replace the 8000 with for autfilling in column "E"

That's what this part of my suggestion calculates, it's 1 row before the first row holding the lower data in column "E".

Code:

Cells(2, "E").End(xlDown).Row - 1

So, where you have the macro putting the formula into E2, and then selecting E2,
add the following line after those ones and see if it works.

Code:

Selection.AutoFill Destination:=Range("E2:E" & Cells(2, "E").End(xlDown).Row - 1)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto Fill only Blank Cells in a Column	mbesspiata3	Excel Programming	1	09-22-2016 07:18 PM
Return Sum value of one column from cells not blank in another column	zulugandalf	Excel	3	08-14-2014 03:37 AM
How-TO format cells (FILL) by comparing cells	zanat0s	Excel	1	07-03-2012 04:27 AM