VBA ::相交与匹配方法 [英] VBA:: intersect vs. match method

问题描述

我有一个关于.Match和.Intersect的内置VBA函数的问题.目前，我有2个1维数组，希望将信息合并到一个新数组中.我知道我之前已经发布了有关解决该问题的方法的问题，但是该问题与哪种方法更好有关.一种方法能够比另一种方法更快地将信息整合到一个新阵列中吗?一种方法是否比另一种方法更可靠?

I had a question pertaining to the two built in VBA function of .Match and .Intersect. Currently I have 2 1-dimensional arrays that I wish to consolidate information into a new array. I realize I've posted a question about the approach to the problem earlier but this question pertains to which method would be better. Would one way be able to consolidate information into a new array faster than the other? and is one method more reliable than the other as well?

推荐答案

来自Excel帮助

Excel开发人员参考

Excel Developer Reference

Application.Intersect方法
返回一个Range对象，该对象表示两个或多个范围的矩形交点.

Application.Intersect Method
Returns a Range object that represents the rectangular intersection of two or more ranges.

数组不是范围，因此插值不适用于您所陈述的问题.

Arrays are not ranges, so interset is not applicable to your question as stated.

对您要执行的操作以及原始数据的格式进行更详细的说明将提供更好的建议

A more detailed explanation of what you are trying to do, and what form your raw data is in will allow better advice

这篇关于VBA ::相交与匹配方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！