I'm attempting to write an extension to the VLookup function. I believe I'm having a problem when I attempt to pass an var array an Excel range to the VLookup function.
@xl_func("string name, var r, int c: var")
def blookup(name, r, c):
s = xl_app().WorksheetFunction.VLookup(name, r, c, False)
re: the above, I believe the problem is that the VLookup Worksheet method is expecting an Excel range and not a var.
Is there a way to assign or cast an var to an Excel range that VLookup can digest?
Thanks in advance,