Search results for query: *

Hi msmith Yup it works! I guess I was using WorksheetFunction.IsNA instead of Application.IsNA. Now it works . 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 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