| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Values to next empty cell range
How can I program this? I want to copy c19:g19 on sheet1, to the same sheet,
and paste special(values) to the next empty row in this cell range, K5:O35. Thanks in advance, John |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Values to next empty cell range
Sub findbottom_paste()
Set rng1 = ActiveSheet.Cells(Rows.Count, "K").End(xlUp) _ .Offset(1, 0) Range("C19:G19").Copy _ Destination:=rng1 End Sub Gord Dibben MS Excel MVP On Mon, 10 Mar 2008 16:22:43 -0500, "Aldo Cella" wrote: How can I program this? I want to copy c19:g19 on sheet1, to the same sheet, and paste special(values) to the next empty row in this cell range, K5:O35. Thanks in advance, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy row with an empty cell for each row in a sheet | Excel Discussion (Misc queries) | |||
| Copy from row above if cell is empty in column | Excel Discussion (Misc queries) | |||
| Copy a string text to cell if another cell not empty | Excel Discussion (Misc queries) | |||
| Picking up the last non-empty cell in a given range | Excel Discussion (Misc queries) | |||
| Grabbing the last Non-empty cell in a range | Excel Discussion (Misc queries) | |||
Linear Mode
