为什么我在VBA比赛中收到错误2042？ [英] Why am I getting Error 2042 in VBA Match?

问题描述

我有列A：

+--+--------+
|  |  A     |
+--+--------+
| 1|123456  |
|--+--------+
| 2|Order_No|
|--+--------+
| 3|    7   |
+--+--------+

现在如果我输入：

=Match(7,A1:A5,0)

进入表单上的单元格

3

结果。 （这是需要的）

As a result. (This is desired)

但是当我输入这行：

Dim CurrentShipment As Integer
CurrentShipment = 7
CurrentRow = Application.Match(CurrentShipment, Range("A1:A5"), 0)

CurrentRow的值为错误2042

CurrentRow gets a value of "Error 2042"

我的第一个本能是确保值为7实际上在范围内，而且是。

My first instinct was to make sure that the value 7 was in fact in the range, and it was.

我的下一个可能是Match功能需要一个字符串，所以我试过

My next was maybe the Match function required a string so I tried

Dim CurrentShipment As Integer
CurrentShipment = 7
CurrentRow = Application.Match(Cstr(CurrentShipment), Range("A1:A5"), 0)

无效。

推荐答案

尝试这样：

CurrentRow = Application.Match(CLng(CurrentShipment), Range("A1:A5"), 0)

这篇关于为什么我在VBA比赛中收到错误2042？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！