datarange

Dear All, I need your help in creating a VBA code. I must create a user-defined function to calculate the mean of the N largest values in a range of cells. It is compulsory I use this function: Function MeanOfLargest (DataRange as Range, NbVals as Integer) as Variant DataRange is a range of...

Hello everyone, i am trying to speed up some code I am working on and have a question. The sheet is a log with internal and external worker hours. Unfortunately I can't completely redo the list because it would cause mass hysteria. ;) So I am pretty much just trying to work around it. I format...

This should normally work and I guess the problem would be with the "activecell" syntax, which creates problems since I refer to another workbook. Any idea how to fix this so it works? Googled several questions, but didn't find this specific problem. It keeps returning '1004' error, Method...

****demo.xlsm file link https://drive.google.com/open?id=0B1u8QGSQIxdoeXRvRHd2THVaenM following code is working only for 28 Ranges which is 15849 cells (highlight in red color) but not running with all ranges that past below in brown color Find same value and Changing a cell & tex color...

Let's say I have a Pivot Table that looks like this but it has over 50 rows: <tbody> Letter Hours A 5 C 10 D 8 </tbody> In the table above the Letter B has a total of 0 hours so it is filtered out; therefore, it isn't displayed. I want to create a loop that displays the number of...