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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TFlanagan

    fighting excel 2007 with the OFFSET function

    Wow, I think that's got it. Thank you.
  2. TFlanagan

    fighting excel 2007 with the OFFSET function

    Good afternoon. I am trying to use the OFFSET function to get the value of a cell that is one row above a reference cell. I am using several nested formulas - address, match, vlookup - which return the intended reference cell. That is, what I have built so far returns, for example, $E$40. The...
  3. TFlanagan

    Excel - reading a named range into a formula

    That was one of the things I tried. Excel evaluates INDIRECT(A1) as INDIRECT("NAMEDRANGE") which then goes to =HLOOKUP(B1,#REF!,2,FALSE) What Excel needs to do is somehow read the text that is entered in A1 not as text but as a named range. Is there a UDF maybe that does that?
  4. TFlanagan

    Excel - reading a named range into a formula

    Good morning. I have a worksheet with several named ranges. On a second sheet I am constructing a chart whereby the user can enter one of the named ranges and the chart automatically updates with the data pertinent to that particular named range. The difficulty I have is in looking up the data...
  5. TFlanagan

    Excel '07 VB error using 'do' loops

    I am trying to do similar operations on several different worksheets in a workbook via a macro. The operation for each sheet is being done via a 'Do Until' loop. The first loop operation starts with this line: Do Until Cells(Tomorrow_row, 1).Text = "#VALUE!" The second loop: Do Until...
  6. TFlanagan

    problem with ADDRESS function

    Good morning. I am using the ADDRESS function to locate a cell on a worksheet and then add other values to it. I have this expression: =((ADDRESS(H2,(HLOOKUP(1,'Sheet1'!$DD$1:$EB$2,2,FALSE)),,,"Sheet1"))) This evaluates to: 'Sheet1'!$CE$1 If I try to add 1 to this result I get the #VALUE...
  7. TFlanagan

    Compile error: End If without block If

    Thank you for the help everyone. I've incorporated the suggested changes. The routine will now compile however it still will not execute. I'm now getting a "Run-time error '424': Object Required" message. When I debug, it highlights the 'If' line of the If-Then-Else block. If...
  8. TFlanagan

    Compile error: End If without block If

    Good afternoon everyone. I'm attempting to execute an If-Then-Else block of code. The compiler keeps blowing up; it cannot connect the different parts of my block. I've tried numerous changes with no result. Please help! Thank you. my code: If (MessageBox.Show("Are you using SPOT_IN...

Part and Inventory Search

Back
Top