| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste cell to last row in range
i'm trying to copy a formula from E1 to a range of cells in column c from row
2 to the lastrow in the column. Here is my code Sub Test dim lastrow application.goto reference:="r65536c1" selection.end(xlup).select lastrow = activecell.row range ("E1").select selection.copy set myrange = range(cells(2,"c"), cells(lastrow, "c")) myrange.paste the macro stops at the "myrange.paste" Jack |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| how do I paste range name list? | Excel Worksheet Functions | |||
| How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
| Paste a named range to another range in Excel | Excel Discussion (Misc queries) | |||
| Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) | |||
Threaded Mode
