| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste table in another existing worksheet
Worksheets("Sheet1").Range("A1:Z100").Copy _
Destination:=LastCell.offset(1,0) to drop down one cell after the last used cell. "BrianB <" wrote: Dim LastCell As Range Set LastCell = Worksheets("Sheet2").Range("A1").End(xlDown) Worksheets("Sheet1").Range("A1:Z100").Copy Destination:=LastCell --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy and paste over existing files | Excel Discussion (Misc queries) | |||
| Creating pivot table to Existing worksheet | Excel Worksheet Functions | |||
| copy Data selection from one workshhet into an existing worksheet | Excel Worksheet Functions | |||
| Copy / paste from a table in word .doc to excel .xls worksheet | Excel Discussion (Misc queries) | |||
| adding a pivot table to an existing worksheet- HELP!! | Excel Discussion (Misc queries) | |||
![Dave Peterson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
