dynamic array

Hi all, In Excel 2010, Windows 7, I've created a macro for a pivot table with a dynamic array as source data. I created the array by naming a table with the formula =OFFSET(a1,0,0,COUNTA(a:a),3), so that I could always incorporate new rows of data into the macro each time I run it. The problem...

I am not great with excel macros, so what I think I need is a dynamic array. I have created a function that assigns the color of a cell to a number, and I need to store that number somewhere so that I can sort by it later. The number of cells with colors that need to be assigned a number and...

I have a sumproduct formula below on a summary sheet in a workbook which works fine. I have multiple tabs in the workbook. Is there a way i can reference each tab based on a cell and copy this formula over based on the tab name? =SUMPRODUCT((Burt!B4:G4='Overall...

My issue is with a number of tasks all written in one macro, but one task refers to a dynamic range that the macro needs to copy and past elsewhere in the workbook, but on occasion that dynamic range won't have any data and therefore equal to no range to copy so the code gets stuck, how do I get...

Hey everyone, I have what should be a fairly simple problem that has been taking me forever to figure out. Here is my situation (Using Excel 07): I'm going to be inputting 100 numbers into a column (Say B2:B101) and need to make a histogram out of that at intervals of 1 from the lower bound to...

I have an integer called NumRows that I want to be set equal to a dynamic range. It works for all values other than if the range is only equal to 1. Can anyone help? Here is my code. ' Set numrows = number of rows of data. If (Range("B101", Range("B101").End(xlDown)).Rows.Count > 1) Then...

I have this crazy long formula, but its really not that complicated, a lot of the same stuff repeated... The formula does a check for values in column B8:B32 and proceeds to look in another sheet and report back values. The problem is, the data in B8:B32 is dynamic and sometimes contain zeroes...

I have a question that I am hoping someone can help me with. I have two schedules. One for Headhaul flights and one for connector flights. Not all headhaul flights have a connecting flight. Some connecting flights will serve more than one headhaul flight. I would like to develop a way to pull...

Hi all, I couldn't figure out the syntax to use to specify that all the keywords must be present in search results, so I may have missed a past topic dealing with this. If so, sorry about that. My problem is as follows: When I use (for instance) Row(1:5) inside a Sum array formula...

I am building a quoting program to use in excel. I will have fields - <TABLE style="WIDTH: 402pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=534 border=0><COLGROUP><COL style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1353" width=37><COL style="WIDTH: 52pt...

Hi, I'm very much a newbie to dynamic arrays so apologies if this seems like a trivial question. I have the following vba code, which reads down a column adding the activecell value to the array...it seems to work okay. The reason why I'm wanting to use dynamic arrays is because the number of...