Naming Dynamic Range Until Consecutive Blank Cells

[coda281]

I am importing data into a sheet starting at B3 (8 column width). This data has blank rows separating each line of data. Ideally, I'd like to be able to find a way to paste it with the blank rows automatically removed. How can I assign a name to this range until I have consecutive blank rows? I cannot use a delete (full) row code as I have charts that feed from the source adjacent in the worksheet.

Thanks!

 

[Tricepsratops]

Im not good at VBA but you could rapidly delete the Empty rows by transforming your pasted data into a table, then with the filters, showing only the empty rows, then delete them ,then untable the data. Takes about 30 seconds. If you have to do this everyday, a VBA code would be nice though.