Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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!

Search results for query: *

  • Users: bigb
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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

Part and Inventory Search

Back
Top Bottom