Search results for query: *

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

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

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?

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

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

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

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

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