Try

Worksheets("Sheet1").Range("A65536").End(xlUp).Off set(1, 0).Select

"LizzyBorden1369" wrote:

Hi all,

I am trying to automatically copy a Range and paste this Range at the
Bottom in the destination. How do I find the bottom (after the last pasted
Range)? The Range size is a known constant. Within the Range, Columns and
Data are filled with combinations of Blanks, Text, and Numbers. I'm sure
this is an easy problem, but I new to VBA and just learning all the
methods/functions available. Thanks for the help.