if that is going to be a set range  you just have to select that range.. and when
you go to paste it.. use the pastespecial data only option... if you want more
i'll play a little and post some code  for it.. if it's a set range you can
also name that range to make it easier to select and copy... if however that
is only a maximum  and you want to copy  only available data in that range
dynamically.. then you'd have to use conditional formatting and get the last row
used for the select statement..