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 |
All times are GMT +1. The time now is 12:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com