Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range within a Range
Morning,
I've got a matrix set up in excel which is a named range. I want to extract a subset from this matrix and make this a seperate range that can be called independently. For example my matrix (A1:C3) is named Range1, I want to code in something that will highligt (B2:C3) and make it a range called Range2. The data I want to apply this to is obviously much bigger and the size of Range2 is gonig to vary across runs of the tool it's coded into. Please can you help me with the VBA code to set this up. Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range within a Range
use the OFFSET function
Option Explicit Sub xxx() Dim target As Range Set target = Range("range1").Offset(1, 1).Resize(2, 2) 'matricx in memory ' do something With target Range("F2").Resize(.Rows.Count, .Columns.Count).Value = .Value Range("F2").Resize(.Rows.Count, .Columns.Count).Name = "range2" End With End Sub "michelle439731" wrote: Morning, I've got a matrix set up in excel which is a named range. I want to extract a subset from this matrix and make this a seperate range that can be called independently. For example my matrix (A1:C3) is named Range1, I want to code in something that will highligt (B2:C3) and make it a range called Range2. The data I want to apply this to is obviously much bigger and the size of Range2 is gonig to vary across runs of the tool it's coded into. Please can you help me with the VBA code to set this up. Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range within a Range
rather than dumping in to teh sheet, just do this
Target.Name = "range2" which answers yuor question properly :) "Patrick Molloy" wrote: use the OFFSET function Option Explicit Sub xxx() Dim target As Range Set target = Range("range1").Offset(1, 1).Resize(2, 2) 'matricx in memory ' do something With target Range("F2").Resize(.Rows.Count, .Columns.Count).Value = .Value Range("F2").Resize(.Rows.Count, .Columns.Count).Name = "range2" End With End Sub "michelle439731" wrote: Morning, I've got a matrix set up in excel which is a named range. I want to extract a subset from this matrix and make this a seperate range that can be called independently. For example my matrix (A1:C3) is named Range1, I want to code in something that will highligt (B2:C3) and make it a range called Range2. The data I want to apply this to is obviously much bigger and the size of Range2 is gonig to vary across runs of the tool it's coded into. Please can you help me with the VBA code to set this up. Thank you! |
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) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |