Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting column after end of spreadsheet.
That's because you are pasting the entire column. Change from:
Columns("A:A").Copy To: Range("A1:A" & Range("A65536").End(xlUp).Row).Copy Note that it will still have to fit in the number of remaining rows... K --- Message posted from http://www.ExcelForum.com/ |
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/pasting from document to spreadsheet | New Users to Excel | |||
Copy and pasting from one spreadsheet to another | Excel Discussion (Misc queries) |