ExcelVBA比较A列和B列-ExcelVBAComparecolumnAtoColumnB

1  

Search is not a function in VBA. Unless you have a UDF with that name, the code will throw an error.

搜索不是VBA中的函数。除非您有一个UDF与该名称，否则代码将抛出一个错误。

0  

I've been using this for that kind of function, found in a previous SO thread. It's not a VBS answer, but might be an easier way to accomplish your goal.

我在之前的SO线程中使用过这种函数。这不是VBS的答案，但可能是实现目标的更简单的方法。

=IF(ISNA(VLOOKUP(,,1,FALSE)),FALSE, TRUE)

-or-

或者,

=IF(ISNA(VLOOKUP(,,1,FALSE)),"FALSE", "File found in row "   & MATCH(,,0))

You could replace and with named ranged. That'd probably be the easiest.

您可以替换并使用命名的远程。那可能是最简单的了。

Just drag that formula all the way down the length of your I column in whatever column you want.

只要把这个公式拖到你想要的任何列中。

0  

Replace

取代

Is_Copy = IsNumber(Search(Cells(Row_A, 1), Cells(Row_B, 2), 1))

with something like

与类似的

Is_Copy = InStr(Cells(Row_A, 1), Cells(Row_b, 2)) > 0

IsNumber and Search are not VBA methods, they are worksheet functions.

IsNumber和Search不是VBA方法，它们是工作表函数。

0  

as pointed above search is not a vb method or function. the best way to compare in a excel will be using the VLOOKUP excel function which dont need to write any vba script also.

如上所述，搜索不是vb方法或函数。在excel中进行比较的最好方法是使用VLOOKUP excel函数，该函数不需要编写任何vba脚本。