Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bigb

  1. bigb

    Urgent VB Macro help!

    Hi msmith Yup it works! I guess I was using WorksheetFunction.IsNA instead of Application.IsNA. Now it works . Thanks! Bigb
  2. bigb

    Urgent VB Macro help!

    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...
  3. bigb

    Excel macro - Vlookup

    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
  4. bigb

    Excel macro - Vlookup

    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...
  5. bigb

    Excel Macro

    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
  6. bigb

    excel macro

    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...
  7. bigb

    vb/macros

    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
  8. bigb

    vb/macros

    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...
  9. bigb

    Visua Basic

    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...
  10. bigb

    excel macro problem

    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...
  11. bigb

    Excel Macros problem

    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...
  12. bigb

    Excel Macros problem

    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
See more

Part and Inventory Search

Back
Top