It should depend on what you select to start with. If you select one cell, then you'll get the current region (which will stop at a blank row); if you select all the data first, you'll be fine.