variable range

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. R

    Variable range

    Hi there, I've got a short question: I have two variable ranges: One in row 4, starting in column F One in Column E, starting in row 5 I want to set a range for a macro for these two variable ranges. So one is Range("F4:.....") and the other one is Range("E5,....). I have to find the Last...
  7. S

    Sum Column If It Is Bottom Row Or Do Math

    I am building a spreadsheet for a client to use. The client will add rows as needed but would like to see totals as the bottom row. Is it possible to write a formula that would determine if it was the last row and then insert totals. If not the last row, perform lookups or other math as it does...
  8. M

    VBA Autofill Variable Range

    Hello, I am using MSExcel 2003 and have recorded a macro that I would like to edit but am coming up short on a good solution. The sub routine will insert columns and convert data from other columns using the UPPER function. I have copied out a portion of the macro below and feel that if I...
  9. E

    Auto Sum

    Hello again. My current problem is something I thought would be easy because I thought VBA would have an Auto Sum function, however I have not been able to find one. I'm using Excel 2007. I have a template that has a summary page. The summary page has seven sections, each section length (in...
  10. W

    Insert formula into cells with variable range

    Hi All, Thanks again for your excecllent help in the past. I have a data export function that finds a dynamic range, copies the values and inserts into a new worksheet. This part is working well. What I need it to do next is to insert two columns before the imported data and add a simple...
  11. L

    Select variable Range (by Cells function)

    Hi all, I need to select a range (on a different worksheet than the active one) based on input so I created this code: Where RLocatie is the row number. But I get runtime error 1004 on the second line of code. For some reason Excel can't select the range? Does anyone know what might be...
  12. C

    vlookup in a variable range

    Here's my problem. I have a range that will move down to include all the records with the same value in column 2, however, when I try to lookup a value in this range after the first range has changed, I get an error. I don't know if it helps, but for j=1 c1=2 and c2=143, for j=2, c1=144 and...
  13. C

    Setting a variable range

    I am trying to interpolate between two values that I need to look up. The problem is that the range of values that I need to interpolate for will change. How do I set a range that will adjust to the parameters I need it to? Also, I have left out the interpolation part so any help on this would...
  14. C

    Subtotal and Sumif with variable range

    Hello, I am stumped on an issue. I'm trying to build in a formula into a macro I have. There are a few worksheets that have 2 sections of data. The formula resides in between these sections. For example, section 1 of data will begin in row 2 and go to row 1000, section 2 will begin in row...
  15. C

    Goal Seek Macro w/ Variables

    Hello All, I am having a bit of a problem with the syntax of a Goal Seek Command in a macro and would certainly appreciate any assistance. I have 30 cells which may trigger a goal seek if a certain value is above 0. The cells I am checking for the value > 0 are in D138 thru AE138. The goal...
  16. W

    range based on values

    Hi, I have a series of data that is updated each month. The cells are formulas that feed from other worksheets. so in February, the data looks like this: <TABLE style="WIDTH: 64pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=85 x:str><COLGROUP><COL style="WIDTH...
  17. H

    Sumifs with Variable range in criteria

    I'm looking for a way to use the sumifs function with the criteria refrencing to a different cell, but also being a range. Basicaly I want to change the formula : =sumifs(a2:a10,b2:b10,"<10"), but instead of using <10 as a criteria, it must be refer to a cell (like <$C$2). I've tried...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top