pass

Hi! I have a problem with self-written *.exe program which is working with current directory. When i run it manually, it does fine. but if i try to do it using VBA - the pass to current directory changes (like excel copies it to some directory and run). can someone explain me how excel runs...

Hi, I would like to classify the CITY in an unstructure Address Column in Sheet1 - i have the City table - with ALL CITY NAMES (standard reference table) in Sheet 2 - I have the data i need to parse and classify Requirement - To compare with the city table and assign the numbers based as...

Given a list of 20 numbers between 65 and 100. Anything less than 70 = Fail (F); between 70 - 93 = Pass (P); and anything over 93 = exceed (E). What is a formula that I can use to derive results.

I truly appreciate anyone's help with this. I have scoured forums for days in search of the steps to take. I have a worksheet (a list) with a macro button that sorts the list. I would like to access this list on my phone (excel online), and am fine without the macro function being available...

I'm using Excel 2010. Maybe this is something that cannot be done because I have searched the internet for instructions, but to no avail. I have a string variable that gets entered into the "Cc" field of an email. However, before I send out the email message (through Outlook), I need to check...

I am writing a macro to do some highlighting. The main macro calls several Subs to do some of the work. It needs to pass a list of cell addresses to these subs. I am wondering about the best way to do that. My current solution is to pass them as separate arguments: Sub Highlight() . . . '...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I have a macro in my personal.xlsb that opens a file. I’m trying to change the behavior of the Workbook_Open code in the workbook being opened. I have code in my personal.xlsb...

Hi I am trying to do an overall pass criteria based on multiple conditions of cell colours. I've already set the conditional formatting to turn the single cell red or green based on the cell numerical value, I now want to do the following:- In one column of 10 cells the top 5 cells are allowed...

Hi, I have formulas in column B looking at values column A and showing results such as Pass or Fail. I wanted to use the Countifs to count how many time I had Pass in column B, but instead it counted every word "Pass" found in formulas. How can I avoid counting "passes" written in formulas and...

I'm struggling and need help to do the following: I'm pulling text, which can vary depending on the original result, from one sheet to another. This will show in cells E5:E24 and F5:F24 (not merged). For example, after one review E5 could say "Building" and F5 could say "Post 01.06.2004"...

Hi all so i need help with something tried for about 3 days now and cannot figure it out, ive tried looking at google but to no avail basically i have a huge spreadsheet with differnet headings i need to compare 2 values of each row. Heading "priority" and heading "pass/fail" so if the row...

Hello all, first time poster here. I've run into an issue and can't figure out how to get around it. I have 3 columns that come into play here, Phase 1 (Pass/Fail), Phase 2 (Pass/Fail) and score. I want to rank only the ones that have passed both Phases, giving the failed ones a rank of 0...

Hello Everyone, All reviews I have found, say that 2016 for Mac is a disaster, specifically with regards to VBA. VBA is an area of great concern for me as all of my work is done there. I also ran across some "promises" from MicroSoft to fix the VBE. Has this happened? I have been avoiding...

I am working on a spreadsheet of mostly pass or fail that has comments spaced throughout it. The person who made the spreadsheet used this formula to achieve a pass or fail percentage: =COUNTIF(M18:AX18,"Pass")/COUNTA(M18:AX18) But it counts the columns that have comments as a fail so it...

I'm attempting to modify a small sub that hides columns based on a key string in the header. I'm getting hung up on two points 1) passing the row number of the header and 2) setting the location of the activecell as the default header location. Here's a failing attempt. Sub...

Hi, I have an external sheet (FILE-2) where i have Tabular Data for a Test cycle. There is a Stats file (FILE-1) in which I read from the External Sheet and pass a Sheet Range (2-D Array) into Named Range (CYCLE_DATA in FILE-2). All the above does well. After this, in FILE-2 when i try to...

"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 table and it named emTbl and a macro to select it. Sub SelectEmTbl() ‘Select EmTbl Application.Goto Reference:="EmTbl" End Sub This works fine but I’m wanting a generic procedure like SelectRange(EmTbl) So, how do you modify the procedure to pass a dynamic name range? It looks...