Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Range from Range
Excel VBA:
Let's say I have a range object set to be from B2:F6, and i need to make another range object to be the last row of my original range. (New range to be B6:F6) How would i go about doing this? I tried the .Resize option, but that only works from the top left cell of a range. DK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Range from Range
Another method:
Dim Rng1 as range Dim Rng2 as range set rng1 = activesheet.range("b2:F6") set rng2 = rng1.rows(rng1.rows.count) or with rng1 set rng2 = .rows(.rows.count) end with dksaluki wrote: Excel VBA: Let's say I have a range object set to be from B2:F6, and i need to make another range object to be the last row of my original range. (New range to be B6:F6) How would i go about doing this? I tried the .Resize option, but that only works from the top left cell of a range. DK -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Range from Range
man, it seems so easy when you see it! thank guys!
DK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
How do I create a Range Name? | New Users to Excel | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Trying to create a range in an IF function | Excel Worksheet Functions | |||
how do i create range names ? | Excel Worksheet Functions |