evaluate formula

I have a lot of data (~350 rows) that need to be evaluated against two rows. Imagine the first row is a header, second row and third row are my spec limits. I am basically trying to evaluate whether each of the 350 row items fall within the values specified in Row 2 and Row 3. I will eventually...

Hi to all, I'm trying to understand better how it works certain Array Formula and I see that "Evaluate Formula" is a great way to see step by step how it works the formula. The issue I see is that the window of "Evaluate Formula" is very small and is needed to scroll down/up for each step, and...

i want to find the maximum value in column C corresponding to a value mentioned on Cell M1 of which data is given in Column B the code: max(if(B:B=M1,C:C) when written in one of the cells in the sheet with Ctrl+Shift+Enter gives the result correctly. however when applying the code in vba I am...

Sorry for not being able to explain correctly in the thread topic. I'll try my best to detail down the problem below. Now what I would like the VBA code to do is to paste the ultimate precedent value instead of directly pasting the answer. Consider cells in the below table (A1 as 10, A2 as...

Hi Guys, I am currently making a macro for a button to log queries, I tried to use an IF statement to check if the desired cell is empty, and if not, record the comments on the next cell to the right but it doesn't work, please any help would be much appreciated. See below: Option Explicit...

Hi, I need some help optimizing (or completely replacing) some code. I have a dataset across 12 columns and ~3k rows which have a combination of vlookup and sum formulas. After the vlookup is finished evaluating (5-10 seconds) I would like to replace the formulas for only these cells to be the...

Hi guys! I have a table ("B:G") where the column headers are weeks ("C:E"). And in column G I have different dynamic values. I am trying to multiply the values in range C:E if the criteria in column B is met. So, in short this is what I am trying to do: If value A1 = "dollar" and If column...

Hi I am new to posting in forums, but I have often had good use of other's q and a's. I havn't found a useful answer to my current problem. I have recently startet coding again after 10+ years without (since university) so I am a bit rusty, please bear with me. (My Excel is in my local...

Hello, I'm trying to use the following code to evaluate an array formula across a range of cells: Sub EvaluateTest() ActiveSheet.Range("D2:G2").Value =...

Hi to all. I have many formulas listed as text with no '=" sign in front of them and each formula has a bunch of variables. I am not able to convert this formula to a useful formula and evaluate it to a value. In A1 cell I have the formulas. here is an example: (D+.0625)+(L+.125)+(D+.0625) In A2...

I can use "Evaluate" method to write the formula's result into a worksheet cell for a function like: ActiveSheet.Range("C27") = Evaluate("MAX('Test Data'!K:K)") which works fine and I get the value in the cell "C27" but when I try to use it for a formula like this...

Hi, I've got the following issue: I'd like to enter a condition/validation as a text (so that it's readable and understandable for everyone) and then excel to calculate the value. For example I've got a named range "income" with the values 50 and 70. Now, the first condition is "income<60". I...

Hello! I've a few named ranges, most of it in one sheet. This sheet updates itself (when the workbook opened), from a central worksheet. In the other sheets are the drop-down lists. The first problem I had was that some lists are dependent on the value of an other cell. So I named the ranges...

I've created dynamic formulas in excel. Unfortunately, it creates the formula as a string. To get around this I created a function (Evalu) that using the Evaluate() function to give me the answer. This currently works fine. However, the problem I now is how to apply this to an array. My...

Hi, I'm running the evaluate vba function. Sub Test1() Dim dbValue As Double dbValue = 3.1415 MsgBox Evaluate("SIN(" & dbValue & ")") End Sub Sub Test2() Dim dbValue As Double dbValue = 3 MsgBox Evaluate("SIN(" & dbValue & ")") End Sub The first does not work, but the...

Hi there I'm working in Excel 2007 and have links of the following format in cells: ='2002'!$J$11 If I go to the menu Formulas -> Evaluate Formula -> Step in then I can go to the source of the data in the formula. Is there a more automatic way in which to achieve this? I would like to, say...