Posted by George on January 28, 2002 9:54 PM
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.