Search results for query: *

Is it possible for excel to calculate the number of series which at some point go out of tolerance? e.g. If a series 1 is the lower tolerance and series 2 is the upper tolerance can I check to see whether series 3 lies within this range or not? The number of values used for the upper...

I have a loop which looks down thousands of lines and across 20 cells on each row. The code takes a huge amount of time to run, since it is looped on a lot of files. Is there a way to make the code only look at a line if the line contains colour since many are blank? Thank you

I'm completely new to SQL and would like to know exactly what I can do with it. I want to be able to extract a load of data for a feature, calculate some new values, order the data by date and take the most recent 30 values. Then repeat this for each feature. An example of the value I'd want...

Using a macro I have imported some data and created 8 graphs on a sheet which is then printed. The printout reverts all character formatting to the default sizes. How can I prevent it from doing this so the formatting I specify in the code is retained? I've done this before in other macros...

I have been trying to create some code behind a command button in a worksheet. When it is clicked it links to another sheet and collects data which it then uses to create a graph. I always get an error: ___________________________________________ Runtime Error '1004': Application-Defined or...

Could someone please tell me how to calculate Cp, Cpk, Ppk, UCL(x), LCL(x), UCL(r) and LCL(r) in VBA? Thank you very much

I have three text boxes. If either or both of the first two are checked the third is activated. When both are deselected the third is deactivated, but the check in it is not removed. This makes it confusing for users. The first two checkboxes have the following code. (With OutputData and...

I have created a library similar to: _________________________________________________________ Public Type SECTION Angle as Single End Type Public Type BLADE Section(17) as SECTION End Type Public My_Blade as Blade ______________________________________________________ The number of...

Hi, is it possible to have a variable maximum value for a progress bar? I want my code to run through a number of files in a folder, the number of files varies. I want the maximum value to change depending on the number of files, since it loops through increasing the progress bar value each...

I have a userform which has a text box, a list box, an add button, a remove button and a start button. I want to be able to type text into the text box, hit enter to add it to the list box and type in my next addition. I have each item being added at the top of the list, and want the focus of...

How can I add items to the top of a list box rather than the bottom? I want to type in a word and then click a button which does this in a user form. Thanks in advance

I have files scattered throughout my harddrive and network. The path to them is obviously different, but the final folder and contents are labelled identically. How could I search my entire network for such folders? I tried using a wildcard to specify all locations: "\*\ & MyFolder &...