| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
select copy paste into new book incrementing rows
Next blank row in column A
Dim rng As Range Set rng = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 13:53:02 -0700, mike wrote: It's probably been asked a hundred times, but I am still having a hard time figuring out based on going through others posts. I need a range (say AA3:AB3) to be copied, another file to be opened (we can call it Data.xls) and the range pasted into the next blank row and the file closed. etc. I'm having issues with the "next blank row" part of it. What's the easiest way to achieve this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to stop formulas from incrementing when you copy and paste? | Excel Worksheet Functions | |||
| Select, find in another book, copy, return and paste | Excel Discussion (Misc queries) | |||
| Copy cells from one worksheet and paste to incrementing sheets? | Excel Discussion (Misc queries) | |||
| copy and paste to different work book | Excel Programming | |||
| Select Range every 20 rows copy & paste special | Excel Programming | |||
Threaded Mode
