Copy and paste unknow range into a different worksheet in excel using vba -

I am trying to write a code to copy an unknown number of rows and make it one in a different worksheet I'm pasting in a specific place. So far I have the code seen below. I want to copy data from column A: F, for an unknown number of rows, and paste it from H6 to the beginning. Code "category (" A1 ", last) I get an error." The "Error" object worksheet's method limit is unsuccessful "All help is appreciated." lastrow = Range lastrow = range ("A65536"). Select the range ("A6"). Select the range ("A1", select last.) Select Sheet ("Final") Select range ("H6"). Select ActiveSheet.Paste End Sub < / Div>

If you want to debug it, then you will decide that the last line is -1 . Get rid of Select <(> and everywhere, for that matter). Your limit is . Copy which fixes me:

  sub-test () Long range = "Range" ("A65536") as Dim Dédorado. End (Range ("H6") End Sub   
 Or, Transfer Rates for Bus , I think it will do this (untested):  
  sub-test 2 () set range as a duplicate copy copyRange = range ("A1: F" & Range ("A65536 ") Copy Letter (" Last "). Range (" H6 "). Size (. Row, number, column number). Value =. End of price with