Pasting column after end of spreadsheet.

  • Thread starter Thread starter presence76
  • Start date Start date
P

presence76

I am working on a problem where I have 2 spreadsheets and I am takin
the column from one and pasting it to the bottom of another. This i
just the first column I will be doing this for. I have three others o
the same set of sheets. My code is as follows:

Sheets("pifinal").Select
Columns("A:A").Copy
Sheets("Final balancing").Select
[A65536].End(xlUp).Offset(1).Select

ActiveSheet.Paste

When I hit the ActiveSheet.Paste line I get :
Run time error '1004'
Info cannot be pasted because copy area and paste area are not the sam
size.

Any help would be greatly appreciated. Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill Columns A and B with varying ranges 6
Sorting in Ascending Order 2
Run-time error 1004 paste method of worksheet class failed 3
cut/paste columns efficiency 13
Copy columns and paste with blank column between 5
Selecting cell using range.offset 2
Paste in column B using Last row of either column B, C or D. 10
Copy Data from Closed File to Existing File 0

Back
Top