Hi,

Are you saying that you want to get all the data on the sheet? In your above example, A1:E7, where E7 is the last column used to the right, and row 7 is that last row used?

If so, try the running the following:

Sub test()
activesheet.usedrange.select
End sub
If it highlights the right range, you can easily change the .select to .copy

HTH,