从另一个vlookup中减去一个vlookup，并将结果分配到范围VBA

Question

我正在尝试从另一个vlookup中减去一个vlookup，并将结果分配给我贬低的范围。我得到类型的不匹配。

dim wb as workbook
dim ws1_name as range
dim ws2_range as range
dim range as range

set wb = xxxxxxx
set ws1_name as .....
(all the ranges are set)
    
Dim x As Long
    
For x = 3 To lastr_ws1
range.Value = (Application.WorksheetFunction.VLookup(ws1_name, ws2_range, 27, False) - Application.WorksheetFunction.VLookup(ws1_name, ws2_range, 30, False))

Next