Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
union method for non-adjacent ranges
To the best of my recollection
MMULT is limited to matices with about 73 rows and 73 columns. MINVERSE is about 52 rows x 52 columns. Anyway, it is a lot less than 256 columns. Union will create a reference to non-adjacent ranges, but it doesn't make them into a single area. -- Regards, Tom Ogilvy "felix" wrote in message ... Hi there, I am trying to combine two non-adjacent ranges. The resulting range shall then be multiplied with another range created the same way using the mmult worksheet function. However, apparently the union statement cannot combine non- adjacent ranges, but only adjacent ranges. I am running into this problem because I need to perform matrix calculations with a matrix exceeding the 256 columns a worksheet provides. Any help will be greatly appreciated! Felix Code Note: a and cd are column ranges, b and ef are row ranges Dim Result As Range Set Result = Range("Result") Dim a, b, cd, ef, acd, bef As Variant Set a = Range("a") Set b = Range("b") Set cd = Range("cd") Set ef = Range("ef") acd = Union(a, cd) bef = Union(b, ef) Result = Application.WorksheetFunction.MMult(bef, acd) End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick question on naming a union of ranges | Excel Discussion (Misc queries) | |||
how can I print non-adjacent ranges on one page | Excel Discussion (Misc queries) | |||
printing Union of Ranges | Excel Worksheet Functions | |||
union method for non-adjacent ranges | Excel Programming | |||
VBA union of two ranges | Excel Programming |