variable range

  1. D

    Filter 3 columns of data using 1 criteria, and copy to a different workbook

    Hello, I need to do the following: Being in Workbook1, activate Workbook2 which contains the data below; filter the data in Columns A to C so that only the "c"'s in column a remain ; copy only the visible data and paste it into Workbook 1...
  2. G

    Setting a SetRange to the highlighted selection

    Hi Team, Forgive me for some of my lack of knowledge of syntax and proper definitions on even the beginner details of VBA, but I have a certain scenario I need help with. Basically I have four seperate ranges on one sheet (Stacked on top of each other with one row between each). These ranges...
  3. C

    Using Sumifs in VBA where range changes

    Hi I am using a simply Sumifs formula, however this is across a data range that will change This is the formula and works as is Range("L6").Select ActiveCell.Formula = "=SUMIFS('Apps Indicative Earnings Report'!$K$11:$K$73,'Apps Indicative Earnings Report'!$G$11:$G$73,'INVOICE CALC'!H6,'Apps...
  4. M

    using variables with range(cells) reference

    Hi, I'm trying to build a range based off of variables that are calculated by user input. I have been able to get everything to work except for the range itself. I keep getting the "method of range of object _worksheet failed" error. The input is on one worksheet and the range is on a...
  5. MacroNoob1

    How can I make a macro calculate formulas for a variable number of rows?

    Hi everybody, This is my first post, so a big thanks to anyone who will help! Here's the thing... I routinely export a dataset into Excel that has a different number of rows every time. I would like to make a macro that calculates several formulas at the bottom for each column. For example...
  6. D

    Dynamic range of cells

    Hi, I'm trying to have a range of cells vary according to other factors. INDIRECT(ADDRESS(1;MATCH("Y";AT2:BZ2;0) What is highlighted in red is what I want to change according to other formulas. The thing is you can't put it in text so I don't know how to have it written in the formula to be...
  7. D

    Regrouping values of multiple cells according to variable data

    Hi, I am trying to automate a very long process with excel. I work in a motorsport business and I would like to do application charts automatically in excel. Let's say, a bearing fits on a XXXX 4-wheeler from 1996 to 1998, 2000 and 2002 to 2005. I want to have this written this way : 92-98, 00...
  8. V

    Autofilling multiple columns using a variable

    I'm completely befuddled on what seems like it should be an incredibly easy macro. (Only been working with excel a few days, so please don't hate me because I don't know what Im doing yet.) I'm getting different worksheets in that I plug in formulas across a few rows and then pull them down to...
  9. H

    SumIf / do until loop

    Hello, Instead of using a pivot to calculate totals for my subcategories, I would like to use the sumIf function in Excel VBA. After I dumped my transacation (variable length each month) in Sheet1 (in dutch: "Blad1"), I'm aiming to calculate the totals on a separate sheet ("Som transacties")...
  10. K

    Using Select Case to pass a variable to AutoFilter as Range

    Hello All, First off, thanks for the innumerable solutions, advice, tips and codes that I have used in the past, this is my first post but I've used this forum to solve many an intractable problem. All of my excel / VBA is self-taught, although I have a grounding in programming. Problem...
  11. B

    Excel VBA - Macro to delete nearly duplicate rows based on criteria

    I have a very large excel table that appears as follows: <tbody> Bob OH 3 Bob OH 4 Bob OH 5 Mary OH 2 Mary OH 3 Mary FLA 2 Ted AL 2 Ted AL 3 Ted NY 2 Jim NY 2 </tbody> I want to delete rows leaving only the row with the max value in column 3 The final table should appear as...
  12. B

    VBA Vlookup variable range

    still learning VBA and frequently bumping up to some errors. I currently have the following issue: I have an excel with 2 worksheets (FORM and DATA). sheet DATA contains 2 colums of data: A = lookup value. B = value to be returned. Range (A:B) is named data. sheet FORM column B contains the...
  13. E

    Macro writes SUMIF formula to a cell, Range and Sum_range need to be variable

    Hi all, The following line of code writes as SUMIF formula into cell E1: Range("e1").Value = "=SUMIF(b1:b10,""Materials"",Y1:Y10)" Range for the SUMIF formula always starts on b1 but the amount of rows needs to be a variable Sum_range also starts on Y1 but the number of rows needs to be...
  14. P

    Emailing a Variable Range as HTML

    Hi all so first of all the below code is an adaption of one from Ron de Bruin and not my own code. I have a spreadsheet that has accounts number and information in columns A:D I have Macro Buttons in row one and my column headers in row 2. What I want to do is email A:C from row 2 to the last...
  15. J

    Error 1004 using variable range

    The following five lines of code are inside a loop in which i goes from 1 to 600. When i was 594 a condition allowed these lines to be executed. (The last was in my original code and the others were just added to try to figure out why the last had a problem.) The first three work and the last...
  16. J

    Error 1004 using variable range

    The following five lines of code are inside a loop in which i goes from 1 to 600. When i was 594 a condition allowed these lines to be executed. (The last was in my original code and the others were just added to try to figure out why the last had a problem.) The first three work and the last...
  17. B

    Looping and RowIndex Over Variable Range

    Hi, I am hoping some excel experts could help me with a problem. My data in general; columns 1-17 are general variables, Columns 18-29 are VBA driven IF Then statements based on values in 1-17. Each row can, and most likely will, have more than one 'true' If statement in columns 18-29...
  18. Z

    VBA: Copy variable rows from multiple workbooks to single worksheet

    Hi everyone, I have completely no prior experience in VBA and am a beginner at excel, but I have just discovered the wonders of macros. I am trying to copy and paste values from variable rows (from Row 5 to Unknown) and fixed columns (A to AF) of a specified sheet (named "Movement") from...
  19. A

    In Loop Store Cell Address for Later Use

    Hello, I've been searching for a way to do this for a little while. What I am trying to do is during a loop operation, which subtotals variable ranges, I want to store the locations of the cells that it puts the sum function into. I.E. if based on criteria it determines that range E4:E12 is...
  20. I

    Excel countif to use variable as workbook name

    Hi all I'm a newcomer to this forum so please forgive any non-compliance to any conventions etc. My questions refers to the following (sample) data Column A Column B Column C Workbook Name Criteria Countif(how it should look for correct results) 'abc.xls'!$C:$C...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top