Hi
I am having problem with this statement. Can you help me rewrite it?
If (IsNA(WorksheetFunction.VLookup(r, Range4, 2, False))) Then
Range("X5").Offset(counter, 0).Value = "0A"
Else
Range("X5").Offset(counter, 0).Value = "0B"
End If
Note...
Hi
I tried Worksheetfunction.IsNA() but it does not work.
The problem here is because Vlookup does not return the value and hence there is is error. I am not able to capture it even though I tried your method Could you suggest me another method/ code?
Thanks!!!!
BigB
Hi
I am having problem with this statement. Can you help me rewrite it?
If (IsNA(WorksheetFunction.VLookup(r, Range4, 2, False))) Then
Range("X5").Offset(counter, 0).Value = "0A"
Else
Range("X5").Offset(counter, 0).Value = "0B"
End If
Note...
Hi
I need to write a macro to copy a range of cells in a range say "A1:J2000" in a worksheet and paste it to a new file in a particular folder in my desktop.
Could you tell me what command I need to use and How I do it?
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...
yes I found that range is a predefined function but the syntax seems to be wrong and I am not able to get the right one. can u please check and tell me
Thanx
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...
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...
I have made some "Macro" modification(copy from some previous file) on the excel file but don't know why every time I try to retrieve this file then it will automatically link/refer to the previous excel file/worksheet. Could what how u could help?
Basically, I have to write an...
I have made some "Marco" modification(copy from some previous file) on the excel file but don't know why every time I try to retrieve this file then it will automatically link/refer to the previous excel file/worksheet. Could what how u could help?
Basically, I have to write an...
I have made some "Marco" modification(copy from some previous file) on the excel file but don't know why every time I try to retrieve this file then it will automatically link/refer to the previous excel file/worksheet.
Can u give me some suggestions
Thanks
bigB
