| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cells that vary in range
Thank you!!
"Vergel Adriano" wrote: try replacing this line Range(rStart, rEnd).Copy with this one Range(rStart, rEnd).Copy ThisWorkbook.Worksheets.Add.Range("A10") .. if the destination is on a sheet that already exists, for example, a sheet named "Sheet2", then, you can do it this way: Range(rStart, rEnd).Copy ThisWorkbook.Worksheets("Sheet2").Range("A10") -- Hope that helps. Vergel Adriano "BCLivell" wrote: I forgot to ask about my next step which is pasting that range into another worksheet starting at cell "a10" in the new worksheet. Thank you! "Vergel Adriano" wrote: Hi, here's one way : Sub test() Dim rStart As Range Dim rEnd As Range Set rStart = Columns(2).Find("start example 1") Set rEnd = Columns(2).Find("end example 1") If Not rStart Is Nothing And Not rEnd Is Nothing Then Range(rStart, rEnd).Copy End If End Sub -- Hope that helps. Vergel Adriano "BCLivell" wrote: Hi everyone! I need some assistence to come up with come code that will copy a range of cells from a single column. The text in the first cell and the last cell are always the same. But sometimes there could be 5 cells inbetween and other times there could be 100 cells inbetween. Below is what I ahve come up with to so far to show where I am trying to go. Thank you for your help!! startrow = Columns(2).Find("start example 1").Select ActiveCell.Copy ******Need to also copy all cells inbetween here**** startrow = Columns(2).Find("end example 1").Select ActiveCell.Copy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vary the Range in a Function | Excel Worksheet Functions | |||
| How do I create a macro that will select a range that can vary in | Excel Discussion (Misc queries) | |||
| INDIRECT / Setting to vary a range? | Excel Discussion (Misc queries) | |||
| Subtotals in a range that could vary in size | Excel Programming | |||
| How can I vary graph color by range value | Charts and Charting in Excel | |||
Threaded Mode
