| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting column after end of spreadsheet.
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 -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting column after end of spreadsheet.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting Spreadsheet into Word | Excel Discussion (Misc queries) | |||
| Pasting dates from one spreadsheet to another | Excel Discussion (Misc queries) | |||
| Pasting from another spreadsheet changes formatting | Excel Discussion (Misc queries) | |||
| Copy and pasting from one spreadsheet to another | Excel Discussion (Misc queries) | |||
| Pasting column after end of spreadsheet. | Excel Programming | |||
Linear Mode
