本文介绍了为什么我在VBA比赛中收到错误2042?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

限时删除!!

我有列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?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

1403页,肝出来的..

09-08 11:17