wrong

Hey guys... This is going to be hard I think. If Range("i" & i).Value >= 0 Then Range("P" & i).Value = "/1000" What I'm TRYING to do is if values are found over 0 in column i then divide values from column i in column p Obviously this code is wrong - As all it's doing is placing "/1000". Is...

Row 100 contains the Text "Comments". With the cursor always on row 26 of the active column, the following code is not working correctly Cells(74, ActiveCell.Column).End(xlDown).Offset(1, 0).Select ActiveCell.Value = TextBox1.Value It should put a new value from Textbox1 of Userform1 below...

Hi, I have pivot table with a date column. Added to this table is a measure (set to calculate minimum) where the formula is just a reference to the pivot table date column. In other words 'Date' column = Measure column. When the table is ungrouped, everything appears as it should, but when I...

Hi I'm trying to amend the formula below so that the result is the sum of all data in the respective columns and rows matching cells C19 and E17. I might have the totally wrong formula! =INDEX('Cashflow labour'!$CM$26:$EA$128,MATCH($C19,'Cashflow labour'!$CM$26:$CM$128,0),MATCH(E$17,'Cashflow...

I am trying to test a cell ad see if it is blank and if it is return a blank the target cell. If it isnt blank I want the rest of the statement to run. My syntax is wrong somewhere..... IF(C4 = "","",(OR(AND(TODAY() <> E4,F4="Complete"),AND(TODAY() < E4,F4="In...

I am so close with my macro... This is my last error. I am using the ActiveSheet.Range("").Select method, and it is doing the following: ActiveSheet.Range("A6").Select 'works like a charm for exactly what I need. I am copy/pasting between files, and using this works. I would like to use the...

Hi, I'm back for the 2nd day in a row seeking help :(. I'm certain the Run Time Error 91 I am receiving while trying to create a loop is VBA just being prissy. I used a nifty error handling code that a member gave me yesterday and I was about to bid the error good riddance but now my OCD is...

Hello all, I have the following code in a module and it does not display the message or save the workbook before closing it.What i am doing wrong?! Thank you in advance. Public Sub Workbook_BeforeClose() MsgBox "Save" ThisWorkbook.Save End Sub

Hello, anyone want to take a stab at what is wrong with my formula? =if(and([@inches]=0,[@[Length feet]]=6),6,if(and([@inches]=0,[@[Length feet]]=8),8,if(and([@inches]=0,[@[Length feet]]=10),10,if(and([@inches]=0,[@[Length feet]]=12),12,if(and([@inches]=0,[@[Length...

In my worksheet I have continuous rows with data in D7:D726. I column E I have data from E7:E24. I need to copy the data in range E7:E24 and autofill the remaining rows in col E (i.e. E25:E726) with that range of values. The ranges in both col D and the initial range to be copied in col E...

I put this formula in my spreadsheet to help put "pass" or "passes" according to the number on the cell I chose to use. here is the formula...

I typed the following command: DoCmd.GoToRecord acDataForm, Me.Parent, acNewRec I am getting the following error: Runtime error ‘2498’: An expression you entered is the wrong data type for one of the arguments.

Hi, This is the first time i work with Power BI and created a "new quick measure" Hours * Cost SUM('DD_BE_QT_SMO_Services'[Cost]) * SUM('DD_BE_QT_SMO_Services'[Amount_Of_Days]) Hours * Rate SUM('DD_BE_QT_SMO_Services'[Rate]) * SUM('DD_BE_QT_SMO_Services'[Amount_Of_Days]) And this works in...

I have a text box that I want to have the values removed when the spreadsheet is opened. What is wrong with this code? Sheets("Home").ListObjects("txtActivities") = ""

Can someone please take a look at this formula and help me figure out what is wrong or maybe a better way to accomplish this? Thanks. =IF(AND(D13<$A$5, Recruitment_Package!$I$9={"In Bank Footprint"}), (D13*$B$5)/10000, (D13*$D$5)/10000, IF(AND(D13<$A$6, Recruitment_Package!$I$9={"In Bank...

ok so im trying to modify an array and past it into another worksheet my problem is when i commit it nothing happens. what am i doing wrong?? thanks in advance

Hi I'm trying to use a filter on a number of cells and want the value to update, I originally had =SUMIF(BJ8:BJ202,"Yes",O8:O202) I have this formula but it returns zero value, any idea what is wrong? =SUMPRODUCT(SUBTOTAL(9,OFFSET(BJ8,ROW(BJ8:BJ202)-ROW(BJ8),0)),(O8:O202="Yes")+0) Any help...

Hi, everyone. When I try to use the formula below, I always get the error in Excel saying " You've entered too many arguments for this function." What do you think is wrong with the formula below and how can I correct it...

I can't find where I'm going wrong with this formula! Can someone help? =IF(AND(S3=S2,V2>Noon,V2<One),V2+TIME(1,0,0),IF(AND(S3=S2,V2>TIME(1,0,0)),V2),if(not(S3=S2),nine)))

I have two columns .........in cell a1 the number 148.5 in cell b1 the formula =RIGHT(a1,1) the result 5 I'm fine with that now in cell a2 I have the number 148.0 in b2 the formula =RIGHT(a2,1) the results I'm getting is 8 I want it to be 0 what am I doing wrong Thanks everybody as always :)