dynamic range variable

Hi I'd appreciate help on the correct syntax for a SUMIF formula using dynamic ranges from variables The following basic formula works great, but I need to use dynamic ranges and have failed in my attempts =Sumif(A:A,A5,K:K) this sums the values in Column K where the value in Column A matches...

Hello, I'm trying to do either a sumifs or index(match() in order to sum a range of cells (multiple columns and rows) based upon a reference cell which can be modified to adjust the number of columns which are summed. For example, in the below table on the right are my results. Since A1 is 3...

Hello MrExcel Gurus, I have a question that I bet has a simple answer, I just haven't run across it yet. I have code that I created in order to take two dates and list in order ever date in between the two in column A. This is working as expected, but now I need to change the startCell...

Howdy. I am new, not just to this forum (although I've trolled it for years when I need help), but new to macros and VBA. As well, there are a lot of threads about this topic, but I can't seem to find one that answers my specific question, or, and more likely, I'm not savvy enough with VBA to...

I am trying to adjust the code so that it cycles through the sheets using a range variable rather than hard coding Range ("O4"). However, when I run the code, it works on the first sheet and then gives me a run-time error '1004' when it gets to "MyRange.Select" - Any ideas what I am doing wrong...

I have a workbook with 2 worksheets. Worksheet 1 has data entry table while worksheet 2 has 2 columns for a list of names and their departments I have a worksheet change procedure in worksheet 1 that does 3 things: 1. Checks if the cell(s) changed are within a specifc range of that worksheet...

Hi, I would really appreciate if you could help me with something that I think it is not hard for someone that knows vba well. I don't. :confused: I am trying to select a range whose end is variable. The end of the range is dependent on a formula that tries to find unique values. The fomula is...