fail

Hi - I am going crazy trying to figure out why my code is not working. For context, this code is copying in a row - finding a value in that row ("NeedVal"), and then dividing that value by an increment (e.g. $1.5B / $500M = 3), takes that multiple (3 "MultiVal"), and pastes that increment...

Hello, I've got this VBA code below (mr excel members wrote it for me and it works great) for a worksheet. However It does not work if worksheet is protected with password. Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Intersect(Target, Range("B23:HN23")) Is Nothing Then If...

Hi all, I have 12 column cells O8-Q31 (merged cells), each with a dropdown of N/A, 1, 2, 3, 4, 5 in. O32-Q33 is one cell & gives me a result. This result shows that all 3s result in 100%, ignoring any N/As. =IFERROR(SUM(O8:Q31)/SUMPRODUCT(ISNUMBER(O8:Q31)*3),"") I need to add extra criteria...

Sorry, but I've spent an hour looking for answers for this problem, and although google returns thousands (probably) of pages of results, I can't find an answer. I was basically wondering if there are any properties that a worksheet holds that stops it from being selected / copied via vba code...

I am using Excel 2010 and Window's 7 Enterprise. When I click on a hyperlink in a worksheet that is linked to another spreadsheet file all I get is the little circle that just spins and does not go to the assigned file. I have dozens of links on dozens of worksheets of which none are now...

I'm trying to embed a vlookup into an if statement. My formula is the following: =IF(I3>50%,VLOOKUP($B3,Sheet3!A:J,10, FALSE),"10% off any service over $100") I bascially want the VLOOKUP to be the "True" return. If I3 is more than 50%, then Vlookup from the other sheet, if it's less than...

Hi everyone, This is my first post so I hope someone can help me out. The VBA macro that I have written is essentially a glorified transpose function (the specifics shouldn't be important for my question). Midway through the code I need to delete a large range of cells so that a) the formatting...

Hi everyone, I have no problem in using a single userform which consists of several label controls which I use to reveal several data produced on the fly. However, when I try to define a second userform and reach both userforms to update relevant label controls in each userform, then I have...

"Hi, and thanks in advance for any help! I am trying to automate some the functions of my student's English progress, based on individual test scores. There are 5 data and 1 results columns. 2 of the tests have a fail/pass component that even if the cumulative score would be enough to pass...

I have a set of web queries from Autotrader.com that has worked successfully for the last few years, but has now started making Excel crash before it refreshes. I'm also unable to Export a page from Autotrader to Excel. Excel opens and nothing happens. It's happened on two different computers...