Search results

Hi everyone! I've migrated to Excel 2013, and noticed that strangely all code runs waaaay slower. Not only that, but also the screen goes completely white while code is running- WEIRD. I was using 2010 before and it worked just fine, never had this issue. Actually not even when I was running...

Hi there everyone I'm going crazy with this one. Can't seem to make a UDF to work to count how many cells are colored "green" or X by conditional formatting. I've looked everywhere and only found UDFs that tell you whether there is a condition or not, or what the possible colors are if any of...

Hi community, hoping you can help me with the following: I have a form where different aspects of a student are rated, each having different weights. Form is composed of 2 different sections, and each category is rated from 0 to 3. Depending on the weight for each category (they vary), student...

Hi everyone, hoping you can help come up with a solution for the attached file: each row represents a respondent, and they were each given a bucket from 0 to 100 points to allocate to a number of sports activities. There are 9 possible activities, but not all respondents had the option to see...

Hi everyone, long time away from this forum. I bring a tough one (I think) and is more of thinking an approach than coming up with a formula. I'm a 2007 user, and I have the attached scenario. Basically, I'd need to pull a list with the Region (column I) and Username (column J) based on whether...

Hi! Trying to figure out why this conditional formatting code (Excel 2007) is not working. It's two relative conditions: - one adds borders on an entire range if the first cell in that row is not empty. - the other condition colors a cell in just column1 of that range, if that cell is equal...

Hi forum! Let's see if I can explain this one clearly: I need to compare an array of multiple columns and rows, to another of 1 column and equal number of rows. The comparison needs to be row by row, for example as you'll find in the attached example, compare all values in C3:E3 to F3, and...

Hi everyone! Hoping you can help me rethink/rewrite properly the following bit of code; scenario is the following: In column "A" I have a bunch of words, singular and plural both, and next to each word (column "B") there's a number indicating the number of occurrences for each of them. What I...

Hi everyone! I'm facing quite a challenge on this one. I have a table on a worksheet that needs to stay locked (users can't modifiy the cells) but still users should be able to filter and sort that table. I have tried everything and saw forum solutions but none work. Here's my best shot so...

Hi everyone, I'm trying to enter a long array formula through VBA, by using the method posted here I'm struggling though, can't find a way to make it work. If there's another way around it, I'm completely open. Code is: Sub Array_Formula() Dim FormulaPart1 As String Dim FormulaPart2 As...

Hi everyone! Question: I need to count with several criteria and ranges, only that one of those ranges can include multiple criteria. For example, in column A:A, the criteria "Jan", "Feb" and "March", and then continue with the rest of ranges and criterias (for example, B:B, "Car models", C:C...

Hi everyone! This is probably an easy one but I just can't figure it out. In a countifs formula, I want it to skip a certain set of range and criteria- let's say the 2nd and 3rd- if a certain condition is met. For example, something like...

Hi everyone, I've been dealing with this one for a while now, hoping a more experienced vba user found a solution/workaround of some sort. When using activex listbox (inserted on sheet, not userform), it happens that when another user opens the file the listbox starts behaving funny. It...

Hi all! Can anyone point me in the right direction to writing a UDF for a MATCH capable of matching cells with over 256 characters? Never written a udf before. Thank you!

Hi community! Some time ago I came accross this code (from Ozgrid I believe), and have been working on different approaches to make it faster (when there's a lot of text, it can take some time). What it does is extract all unique words from a range, and count the number of times that word...

Hi everyone! I'm trying to check if a combination of 2 or more words are cotained in a given cell. The only problem is that I only get it to work if the words I'm looking for are one after the other- If they are in a different order, or have words in between, I'll get a FALSE. Hope it's...

Hi everyone, having a bit of a headache with this one, hopefuly someone out there has an idea. I have a rather complex dashboard that's not working on a specific person's computer. It works fine on mine, as well as many other computers, but not on this other person's excel. It's difficult...

Hi everyone! I'm having a tough time with this. Is there any way to convert any text file format for Excel 2007 to read without problems? I'm writing some code that does text processing, and it works fine with text from Excel 2007, but now I was given a file that apparently has a different...

Hi everyone! First of all, congrats on the new forum! I'm having some trouble with the following: I'm trying to move a shape, based on another shape's location (Application.Caller). So that when I click on that shape, the other shape will move (called "mover", for example). So I tried the...

Hi people! I'm having some trouble with looping through all shapes in a sheet, and hiding if they meet a text criteria. If text in any shape is equal to "no", then the shape should be hidden. Here's what I thought would work: Sub Text() Dim shp As Shape For Each shp In Sheet1.Shapes If...

Hi everyone! Some time ago SirJB helped me with this code to loop through 2 columns of text and delete the rows whenever a certain criteria is met. I'm facing a new challenge now, I want it to search for several words, like 200, and delete the row whenever any of those words appear. Also...

Hi! I'm looking for a good screen recording software, the kind you use to record tutorials. I read that Chandoo uses Camtasia, but I've looked it up and it's a paid application (even though it has a trial). Does anyone know about a good/free-of-charge alternative? Thanks!!!

Hi everyone! Here's a question I've had for some time. It's mostly about the visuals of excel reports, but I'd love to have a way for excel to show something- a clock, a pop up, anything- that indicates the progression of a macro as it's running. I've looked online and found pretty cool...

Hi everyone, I'm having some trouble with something that's really simple and can't get it to work. Hopefully someone will be able to shed some light. Basically, I need VBA to compare two ranges (of the same lenght) and, if they are equal, do something. Like this: If...

Hello everyone I have the following scenario: I need to make a SUMIF, where the criteria might be repeated several times in the criteria range, and the criteria range is made up of multiple columns, let's say A1:N200. So, it would be (if this was possible) like...