evaluate

Hi All I am looking for the cleanest way to pick selected rows of data and copy them to a different sheet where they will be used for dynamic graphs. The data on the first page will differ in size greatly, from 10 - 6000 rows, as it is an import from another system. I have looked about online...

With the code example below I'm trying to loop through the collection and call a few custom class functions. What I'd like to do is loop through an array of the class functions and call them using application.run(). In the example below the "IsWidthOK" function would run, then I would loop...

I am using the following code to name a range in my worksheet and then dividing every cell in that range by the corresponding cell in column B and multiplying it by the corresponding cell in column A. Nothing happens when I run the code like it is, but if I substitute a range (like AU4:AT) for...

I have a question regarding some VBA code I am writing. It seems to me there should be a simple answer but I haven't been able to find it out. I want to write a macro to evaluate the selected cell by means of a formula and take action based on the results. I will illustrate it with an...

I think my previous post went a little haywire with font formatting so created a new one to freshen it up: HiI've done a bit of digging and found that EVALUATE could allow me to put the resulting value into an array. When I've modified the relevant section of code to put the resulting value to...

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 am not sure why this is not working, but my objective is to simply evaluate the following: If Me.Ncb.Value (the value from my userform) is present then MyIMPBucket = Me.Ncb.Value MYHCDBucket = Me.Ncb.Value Private Sub Ncb_Change() If (Me.Ncb.Value) Like "*" Then MyIMPBucket =...

Like any good topic on MrExcel, this one begins with me pulling my hair out in frustration! I've constructed a fairly straightforward Index/Match formula that involves a couple of columns within Tables in Excel's main interface that looks something like this: =INDEX(A_OpenClose[Total Open...

So I've previously used Bash to do this. I was wondering if it's possible in VBA. I have a variable (let's call it ii) that will change based on a function...etc I then have another set of variables let's call then a1, a2, a3. Is it possible to do something like evaulate(a & "ii")? to get...

Hi, I'm trying to insert a random number into the unprotected cells on a worksheet depending on the type of number formatting in the cell. There are 4 basic cases: Number formatted as percent Number Formated general with no decimal places Number formatted general with two decimal places...

Hello all, I'm not brand new to VBA but for me this is overcomplex. Hope you can help in this case. I would like to create a macro which does the following to a column of dates: For each cell in the column/range it should check if the date in that cell is present in a named range (Bdays)...

I have the following code run by a macro to populate a cell with the value of an array formula using the evaluate function. The formula works but it rather slow and I have several of them in a row that need to execute. ActiveSheet.Range("O4").Value = Evaluate("MEDIAN(IF(E:E=M3, IF(I:I>0,I:I...

I have a series of golf scores in rows. For the purpose of this league, we use your last three scores to determine your handicap. If you have played 1 or 2 rounds, we use your handicap for the one round or the two rounds. A typical row might look like this 85 0 84 88 0 81 86 0 85 The 0's are...

Hi, This particular project has me stumped. I'm trying to design a macro which loops through a range and checks whether the cell fill is red, it would then paste the cell address in another sheet. That part is all fine, the problem is that the cell is highlighted red as a result of a conditional...

Step1: Select range 'A1:B5' Step2: Fill with numbers Step3: Apply this FormatCondition: Formula '=A1=2', with Red Font. Then, all cells with contains number 2 are Red. Step4: Select cell 'B2' In VBA, Excel 2003: Msgbox ActiveCell.FormatConditions(1).Formula1 shows: '=B2=2' In VBA, Excel...

Hi all, I need to evaluate values from a list on one worksheet and summarize the answers on to another worksheet using specific logic. I don't write code so I seem to be lost. I can't figure this out based on other examples given because it's not an exact match to mine. here goes... Working...

here is a sample code: Public Function getest(esttype, yr) Dim strf As String strf = "=counta('m:\folder\mds\[rating index.xls]" & esttype & Right(yr, 2) & "'!$1:$1)" MsgBox Evaluate(strf) End Function for "sales" and 2009, what strf reads is: =counta('m:\folder\mds\[rating...

Not sure if this is possible. I want to evaluate an array, actually a defined section of an array with a worksheet function. I know how to do this with a worksheet range like this... x = Evaluate("Worksheet.Function.Sum(.Range(" & .Cells(1, 2).Address & ":" & .Cells(2, 2).Address & "))")...