Filling blank rows from the last non-blank row

[CARLTON BROWN]

I WANT TO BLOCK A 66,000 ROW COLUMN AND FILL BLANK CELLS FROM THE CELL ABOVE. I HAVE BEEN USING EXCEL FOR THREE YEARS AND CAN WRITE MACROS AND I STILL DON'T KNOW HOW TO DO THIS. I HAVE TRIED AUTOFILL EVERY WAY I KNOW.

 

[Andrew Poulsom]

Please don't SHOUT.

What do you mean "block a 66,000 row column"? There aren't that many rows in Excel. That said:

Range("A65536:A" & Range("A65536").End(xlUp).Row+1).Select

will select all the blank rows from the last entry in column A.