Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
merge ranges
The union function is used ot merge ranges. Try something like this...
Function (a, inputX as Range, inputY as Range) dim rngMerged as range set rngMerged = Union(inputX, inputY) -- HTH... Jim Thomlinson "Greg" wrote: Hi, i have a function as follows Function (a, inputX as Range, inputY as Range) I need to sort both ranges in asc order by inputX. I am thinking of using CurrentRegion.Sort command. To use this I need to merge these ranges into one range so that my inputY range would get sorted . How would i do this? Thanks a lot, -- ______ Regards, Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge named ranges ? | Charts and Charting in Excel | |||
merge named ranges | Excel Worksheet Functions | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
Merge ranges based on condition | Excel Programming | |||
how to merge ranges from multiple worksheets | Excel Worksheet Functions |