Hi!
This macro works when I decide what cells to copy:
Set sourceRange = mybook.Worksheets(1).Rows("1:200")

But how do I write a macro that copies al the rows untill first empty row in
the sheet?