bigb (Visitor) Jan 24, 2002
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
Is range a predefined function which can be used in vb/macro
Range("abc" is supposed to calculate the range of the spread sheet "abc".
Could you help me fix this problem.
Thanks
bigb
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
Is range a predefined function which can be used in vb/macro
Range("abc" is supposed to calculate the range of the spread sheet "abc".
Could you help me fix this problem.
Thanks
bigb