I am trying to take 4 columns from one spreadsheet and paste it to th
bottom of another. I am doing each one seperately. The first on
worked fine. The second one did not because I need to save th
location of the bottom of the sheet and then reference that with a
offset of 1,1 to move it to the next row, next column. When I do tha
I get run-time error '1004' - method 'range' of object '_global
failed.

Here is my code:

Dim bottomofsheet As Long

Sheets("tracerfinal").Select
Range("E1:E" & Range("A65536").End(xlUp).Row).Copy
Sheets("Final balancing").Select
bottomofsheet = Sheets("Fina
balancing").Range("A65536").End(xlUp).Row
[A65536].End(xlUp).Offset(1).Select
ActiveSheet.Paste


Sheets("tracerfinal").Select
Range("D1:D" & Range("A65536").End(xlUp).Row).Copy
Sheets("Final balancing").Select
Range(bottomofsheet, 1).Offset(1, 1).Select
ActiveSheet.Paste

The error happens on the
Range(bottomofsheet, 1).Offset(1, 1).Select line.

I have tried several variations including changing the dim from Long t
object to range and then modifying accordingly.

Any help would be greatly appreciated. Thanks

--
Message posted from http://www.ExcelForum.com