excel macro
excel macro
(OP)
Hi
when I run my macro for excel in Visual basic I find this error:
Runtime error 1004
Method 'Range' of object' - Global' failed
I think the error is in this statement:
y = funct("abc", Range("abc"), 1)
--------------
The function has been defined as follows:
Declare Function funct Lib "hello.XLL" (ByVal sheetName As Variant, ByVal Range As Variant, ByVal lockFlag As Variant) As Long
I tried y = funct("abc", "Range(abc)", 1)
but then the program is working and result is wrong
Could you help me fix this problem.
Thanks
bigb
when I run my macro for excel in Visual basic I find this error:
Runtime error 1004
Method 'Range' of object' - Global' failed
I think the error is in this statement:
y = funct("abc", Range("abc"), 1)
--------------
The function has been defined as follows:
Declare Function funct Lib "hello.XLL" (ByVal sheetName As Variant, ByVal Range As Variant, ByVal lockFlag As Variant) As Long
I tried y = funct("abc", "Range(abc)", 1)
but then the program is working and result is wrong
Could you help me fix this problem.
Thanks
bigb





RE: excel macro
Function funct(ByVal sheetName As Variant, ByVal Range As Variant, ByVal lockFlag As Variant) As Long
Secondly for the function call:
y = funct("abc", Range("abc"), 1)
to work, "abc" must be a named range in the workbook - and from the look of your function, should most likely contain a string...
Good luck