dynamic arrays

Hi. I'm not sure this is possible but here goes. And thanks in advance for any insight, even if that insight is "you can't". I have a number of dynamically sized, named arrays that I want to repeat in a column. For instance, the baseline array might have four values in a column (representing 4...

Dear All, I am struggling trying to set up a code in VBA to create a chart in the active w/s. This chart should be a scatter line with no markers. The x values are constant for all the series (column A from A19 - the end will be dynamic). The y values will vary. The number of series will also...

How would I add Multiple rows in active worksheet (Values to be taken from TextBox)?

VERSION Excel 2013 (15.0.4631.1000) SUMMARY OF ISSUE Creating a dynamic VLOOKUP within a expanding/contracting column range BACKSTORY Within my business, I have an internal reporting suite of which I export monthly sales data. The data details which shops have generated sales. Some months all...

Probably a newbie question, but I have the formula below that finds rows wherever column Q is blank and sends back the row number {=IF(ISERROR(SMALL(IF('Production Meet. Mins '!$Q$13:$Q$99="",ROW('Production Meet. Mins '!$Q$13:$Q$99)),ROW(1:1))),"",SMALL(IF('Production Meet. Mins...

-- Sample Data--- <colgroup><col width="64" span="4" style="width: 48pt; text-align: center;"> </colgroup><tbody> <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Grandparent Parent Child Fee 1 ON A 5 1 ON B 10 1 ON C 15...

Hi everyone, I have been searching for a formula that would do the following, extract unique values from a frequency chart..Please excuse me I am new to this form and limited knowledge of excel. (I am not a spreadsheet master..lol) example of the chart: <tbody> a b c d e 1 gas 205 2...

Excel 2010 <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead> A B C D E F G H I J K L M N O P Q R </thead><tbody> 1 Project Budget 2 3 Project Name...

I'm trying to use an array to store offset values that refer to cells whose contents I want to change only while my macro is running, and then at the end of the macro I want to revert to the value I had when the macro started. The cells can only contain "include" or "exclude", which control...

Hello All, What is the best way to populate a text box with a comma separated list of file names at a directory? Can someone show me what an array might look like for an in determinant number of file names (1 to x) perhaps?) Shaun

Hello All, I am trying to figure out how to get this spreadsheet to wrok the way I need it to. I insert the "Green" portion below from "NotePad". It is always in this order and format. I need to track and total when personnel use too many of the same "Recipe" in a given time period. I have...

I am trying to fill a dynamic array with the row indexes from a search function. So far I have created a loop that introduces a leading or trailing 0 to fill the array. I would like to fill the array without the 0 but my current code keeps giving me a 'subscript out of range' error. This...

Hi, Below is my code that will loop through a workbook and print each worksheet individually. I'm now trying to add code in order to find worksheets with the same account number in the sheet name and group them - then print, and move on the the next account... below is an example of 2...

Hi I am new to this forum, and would like to get help on the usage of array inside a combo. I am tring to populate a combo box (single coulmn) with an array (dynamically created) . But Iam not sure how to do it. Would like to get get help from this forum I am trying to get something like...

Hello, I'm fairly new to VBA and I was wondering if anyone could offer some suggestions to cut down on the ammount of If statements used in my code. This is only a snippet as there are about 126 arrays with anywhere from 5 to 136 elements per array so the less I need to use If statements the...

Thanks in advance for taking the time to read this! I have a rather large data set, containing over 20,000 records and I am looking to calculate the percentile ranking of 10 to 20 different statistics for each record, in each category, if the statistic exists. Of these 20,000 records, I...

Is there a way to do something like this: Dim Array1 (1 to num, 1 to 5) as variant Excel doesn't seem to like the variable, num. I want to be able to expand the rows as data is entered.