| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Destination:=.Cells(.Rows.Count, "A").End(xlUp).Row + 1
Need to duplicate code but change destination.
' THIS WORKS With Worksheets("Ind Templates") .Range("A1:f13").Copy _ Destination:=Sh.Range("a1") End With I need destination to be the row below the last row used in A. I tried this, but didnt work. Destination:=.Cells(.Rows.Count, "A").End(xlUp).Row + 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I suppress the "Do you want to overwrite the destination cells" message | Setting up and Configuration of Excel | |||
| Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
| myRow = Cells(Rows.Count, 2).End(xlUp).Row | Excel Programming | |||
| Cells(Rows.Count, "b").End(xlUp).Row | Excel Programming | |||
| Macro causes "Do you want to replace the contents of the destination cells" | Excel Programming | |||
Threaded Mode
