| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save a range to copy for later
I want to select a range starting with active cell to the last row and copy
it... but first I have to clear the copy range starting in A3... then paste in A3. can someone help? first = ActiveCell.Address col = ActiveCell.Column lastrow = ActiveSheet.Cells(Rows.Count, col).End(xlUp).Row lst = "r" & lastrow & "c" & col Range("A3").Select Range(Selection, Selection.End(xlDown)).Select Selection.ClearContents Range(first, lst).Copy Range("a3").Select Selection.PasteSpecial Paste:=xlValue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subscript out of range error - save copy error | Excel Programming | |||
| Subscript out of range error - save copy error | Excel Programming | |||
| Save column J only using copy/paste & temporary copy | Excel Programming | |||
| copy formulas from a contiguous range to a safe place and copy them back later | Excel Programming | |||
| How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel | |||
Threaded Mode
