What's the size of your selected range. Is it a single column of values or a range of rows and columns.

If the range you're selecting is in a single column, how many values are you selecting? 1, 40 or a variable number.

What should happen if below the next empty cell (working down) there are cells with values? Or by empty cell do you mean the cell below the one you would find with an End Up cursor movement starting on the last row.

As ever an actual workbook with some specific examples in it is worth a thousand words