Copy range, stopping at blank rows

[bsift]

Hello,

I am writing a script that copies a range from a spreadsheet, but the range could change between the number of lines it exports based on data. I.E. I could have 10 rows or I could have 38 rows. It's going to copy, because my users will use it to paste the data into a different program that unfortunately would not strip out the blank rows. I have the easy part:

Please Login or Register  to view this content.

I just need the code to stop it when it hits a blank row. Can you help?

[maras_mak]

Not enough data.
I don't know if there are only values or formulas in the cells?
For "values only" please download the code below.
The results are from L2.

P.S. It's a good idea to attach the workbook.

Please Login or Register  to view this content.