bigb
Mechanical
- Sep 17, 2002
- 12
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
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
Could you help me fix this problem.
Thanks
bigb